Search code examples
excelspreadsheetgear

Spreadsheetgear - How to set focus on first worksheet

I am working with spreadsheetgear to create excel sheet. I am able to add multiple worksheets. After I add more than 1 worksheet, the focus always remains on last worksheet. How can I set focus on first worksheet after adding multiple sheets.

Solution

  • You can use ISheet.Select() to make a sheet the active sheet. Example:

    using SpreadsheetGear;
...

IWorkbook workbook = Factory.GetWorkbook();
workbook.Worksheets.Add();
workbook.Worksheets.Add();
workbook.Worksheets.Add();
workbook.Worksheets[0].Select();  // Selects the first sheet in the workbook.