We are developing an application to read data from Excel files. The files can be created using any of these three: Excel 95, Excel 97, Excel 2000. We have no issues while reading data from files created using Excel 2000. But for the other two, we are getting an error while opening the files. We opened some of those files manually using Excel 2000 and then saved those, and found the application could read data properly after save. It seems to be issues with 95/97 formats. Is there any way out? Any help would be greatly appreciated.
Thanks.
Dear Rainbow,
Sorry for the problem.
Yes. Excel95 format file has major differences with Excel97 and above version file. Because many new features are added to Aspose.Excel after the first release and most of our users use Excel97 and above version of Excel, Excel95 format support does not keep up with the enhancement.
Your can use your solution to solve this problem: opened those Excel 95 files manually using Excel 2000 and then saved those.
Please send me the Excel97 file which also has this problem, I will investigate it.
@Rainbow,
Aspose.Excel is no more there as we have introduced the latest product Aspose.Cells which has much more advanced features as compared to the previous product. This new product supports loading Excel 95/97 as well.
The following line of code will load the file:
Workbook workbook = new Workbook("Excel95_5.0.xls");
For more information on opening different versions of Excel files, please follow the link below:
Opening Different Microsoft Excel Versions Files
Download the latest version of Aspose.Cells for .NET from the following link:
Aspose.Cells for .NET (Latest Version)
You can download the latest demos here.