Free Support Forum - aspose.com

Missed sheet in the loaded workbook

Hi, Aspose team,
We have an issue with the loading Excel spreadsheet’s content. There is a missed sheet in the document.

The spreadsheet with the issue:C38D2E7CCE7D.zip (17.7 KB)

Workbook wb = new Workbook(fName);

Loaded content:

wb.Worksheets.InnerList
Count = 3
    [0]: {Aspose.Cells.Worksheet[ By Product ]}
    [1]: {Aspose.Cells.Worksheet[ By Product-Customer ]}
    [2]: {Aspose.Cells.Worksheet[ By Product-Customer Filtered ]} 

When the spreadsheet is opened with MS Excel there are four sheets. The first one is missing in Aspose.Cells.
Resaving the document with MS Excel fixes the issue.

Aspose.Cells 21.3.0.0
Microsoft Excel for Office 365 MSO (16.0.13801.20288) 64 bit

@licenses,

Please notice, I am able to reproduce the issue as you mentioned by using the following sample code with your template file.
e.g.
Sample code:

Workbook wb = new Workbook("e:\\test2\\C38D2E7CCE7D.xls");
Console.WriteLine(wb.Worksheets.Count);
            foreach (Worksheet sheet in wb.Worksheets)
            {
                Console.WriteLine(sheet.Name);
            }

Output:
3 --> it should be 4
By Product
By Product-Customer
By Product-Customer Filtered
(Note: the first worksheet “Source Data” is missing)

I have logged a ticket with an id “CELLSNET-47958” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@licenses,

This is to inform you that your issue has been resolved. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@licenses,
Please try the latest fix 21.3.7.
Aspose.Cells21.3.7 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.3.7 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.3.7 For .NetStandard20.Zip (5.5 MB)

Yes, it fixes the issue. Thanks.

@licenses,

Good to know that your issue is resolved by the new fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

The issues you have found earlier (filed as CELLSNET-47958) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao