Free Support Forum -

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.