Free Support Forum - aspose.com

Unknown Sheets

I have a Workbook with 12 Sheets in it. When I open the workbook with Aspose.Excel it tells me there are 23 sheets. This is obviously not correct? Where is Aspose getting the other sheets from? Also, as best I can tell these “Extra” sheets are not ranges either.

This is how I am getting my list of worksheets:

Should I be doing something different?



foreach( Worksheet ws in _xl.Worksheets )

{

this.uiComboBox1.Items.Add( ws.Name );

}












Could you please post your file here? There may be some hidden worksheets.

You are correct, there are 11 hidden sheets in the workbook. I now filter on the IsVisible flag.

Thanks.