it is not completely fixed. I add a pivot table in the spreadsheet, run the code again, the html will show the wrong named range. attached is the new excel file.
Thanks for your posting and using Aspose.Cells.
When there are multiple problems (or its aspects), then it is a good idea to create a separate thread for each problem you are facing or discussing. Since, your thread is linked with the ticket logged inside the issue tracking system, it is preferable that one thread deals with one ticket only. This makes it easier for us to manage and fix your issue more precisely.
Please help us investigate and replicate your issue at our end. Please provide us your sample code. If it is a same code as in your previous thread, then copy/paste it or provide your new code.
Please also provide us your source Excel file used in your code if it is different than the attached file in this thread. Thanks for your help in this regard and have a good day.