We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

InvalidCellName exception

Hello. I'm having an issue with Aspose.Cells.Workbook. Using the Open() method returns an InvalidCellName error. Is someone available to help?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />


This message was posted using Email2Forum by Laurence.

Hi Mark,

Sure, we are here to help you. Please share some details with us. Please send us the sample Excel file and the code snippet your are using. We will look into it as soon as possible.

Thanks,

Thank you for the reply. We have resolved our problem now. One of the sheets had a page split which was very hard to see because the user had dragged to just next to the border of the page. We have also found that if a sheet has a print area, it throws the same exception.

We also found a very helpful way to troubleshoot the issue which others may find useful. First, we narrowed the problem down to one sheet by removing sheets until the error went away. Then, we learned that xlsx documents can be unzipped using an ordinary zip tool, and inside there are several xml documents, one for each sheet. You can find a particular sheet by searching for some text that is only in that sheet. You could write your name in the sheet, for example. We knew something was strange about this one sheet so we just took a look around the xml. We compared it to similar sheets that didn't produce the problem. And pretty soon we found the offending tag in the xml.