This project has moved. For the latest updates, please go here.

Selecting Cells and Ranges

Set the active cell

var wb = new XLWorkbook();
var wsActiveCell = wb.AddWorksheet("Set Active Cell");
wsActiveCell.Cell("B2").SetActive();

SelectCell.jpg

Select cells and ranges

var wsSelectMisc = wb.AddWorksheet("Select Misc");
wsSelectMisc.Cell("B2").Select();
wsSelectMisc.Range("D2:E2").Select();
wsSelectMisc.Ranges("C3, D4:E5").Select();

SelectRanges.jpg

Last edited Aug 20, 2012 at 3:24 AM by MDeLeon, version 5