Iterate Through Worksheets
In a number of scenarios you may need to iterate through all worksheets in a given workbook. The API of the Workbook class exposes a Worksheets collection that allows you to retrieve worksheets both by name and index. Also, the collection allows you to iterate all worksheets effortlessly. The Iterating Used Cells article shows how to iterate the cells inside a worksheet respectively.
Example 1 illustrates how to retrieve worksheets that have already been added to the workbook.
Example 1: Retrieve worksheet
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.Worksheets;
worksheets.Add();
worksheets.Add();
Worksheet firstWorksheet = worksheets[0];
Worksheet secondWorksheet = worksheets["Sheet2"];
Example 2: Iterate worksheets
Workbook workbook = new Workbook();
workbook.Worksheets.Add();
workbook.Worksheets.Add();
workbook.Worksheets.Add();
ThemableColor foregroundColor = new ThemableColor(Colors.Red);
Color backgroundColor = Colors.Green;
IFill backgroundFill = new PatternFill(PatternType.Solid, backgroundColor, backgroundColor);
foreach (Worksheet worksheet in workbook.Worksheets)
{
CellSelection cell = worksheet.Cells[0, 0];
cell.SetValue("The name of this worksheet is: " + worksheet.Name);
cell.SetForeColor(foregroundColor);
cell.SetFill(backgroundFill);
}