I am using Aspose.Cells (Version 188.8.131.52) for importing and exporting Excel files. When importing a file of excel 2007 format, I am getting error as “Error while opening workbook: Invalid formula:”Telcel:Supplier!$B$57:$AD$410"."
The same file when saved in excel 2003 format as xls file, it gets imported without any error. Please suggest any workaround for this.
P.S.: When I use an earlier version of aspose.dll (184.108.40.206), the same xlsx file is imported without any error.
Thanks and Best Regards,
I want to add that I was using the earlier version (220.127.116.11) of aspose till I start getting this error in importing xlsx files "Error while opening workbook: Invalid worksheet name."
My thought was that it was coming because earlier aspose version might not fully support the new excel 2007 format.
Please try our latest version v4.9.0 that we have released now: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry231670.aspx
If you still find the issue, kindly do post your template excel file here, we will check your issue soon.