Get name of all worksheets in Excel book

GemBox.Spreadsheet
1

How can I get a list of all the Worksheets in an open Workbook? I see where I can get a count, and am able to see the count.

2

Hi Herb,

Try this:

var workbook = ExcelFile.Load("input.xlsx");
foreach (var worksheet in workbook.Worksheets)
{
    Console.WriteLine(worksheet.Name);
}

I hope this helps, let me know if you need anything else.

Regards,
Mario

3

Thank you this sample explains a lot.