For a large financial reporting system we need to read a number of Excel files that are exported by 'Business Objects' (http://www.businessobjects.com/). I have this feeling that these export files are not 100% Excel compliant although the various versions of Excel don't have a problem opening them.
However, when I open the file using Aspose.Cells (tried latest version as well) I cannot read values from text cells. Reading numerical data is fine though. I also cannot access other properties such as cell styling etc.
When I resave the file in Aspose and then open the file in Excel then all the text fields and formatting are gone. However, when I open and save the original (BO Exported) file using Excel then I CAN access all text fields using Aspose.cells. Unfortunately this is no option.
I cannot send you the original Excel files as they contain highly confidential information. Is there any other way to troubleshoot this?