facebooktwittermenuarrow-up

GemBox Support Forum

Get name of all worksheets in Excel book

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.

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

Thank you this sample explains a lot.