static void SetSelectedRanges(SpreadsheetControl control)
{
control.BeginUpdate();
Worksheet worksheet = control.ActiveWorksheet;
CellRange r1 = worksheet.Range["A1:B10"];
CellRange r2 = worksheet.Range["E12"];
CellRange r3 = worksheet.Range["D4:E7"];
List <CellRange> rlist = new List <CellRange>()
{
r1, r2, r3
};
control.SetSelectedRanges(rlist);
control.SelectedCell = worksheet.Cells["E5"];
control.EndUpdate();
}
