Aspose generated Excel 2007 spreadsheet issues

Aspose.Cells Product Family
1

It seems that a spreadsheet report generated (Original Report.xlsx) by Aspose Cells cannot be loaded by MS Access 2007. The current workaround is to open the file via Excel 2007 and then resave it (Resaved Report.xlsx).

2

Hi,

I have tested your case using your template file, it works fine. The output file opens fine in MS Excel 2007 and Excel 2010 as I tested.
Here is the sample code:
var workbook = new Workbook(@“E:\test2\Original+Report.xlsx”);
workbook.Save(“e:\test2\outSavedFile.xlsx”);

I am using Aspose.Cells for .NET v6.0.0.1 (attached), please try it.

I have also attached the output file here.

Thank you.

3

The file itself is viewable via Excel 2007 and 2010. However, the data in the file isn’t importable via Access 2010. Enclosed is a screenshot of when trying to import the data from the file you sent.

4

Hi,

Thanks for your feedback and screenshot.

We will look into your issue soon and update you with our findings after importing the data into Ms-Access.

5

Hi,

If you need to import Xlsx file to Ms-Access, you should export cell name when you generate xlsx file, below is sample code:

C#


Workbook workbook = new Workbook(@“E:\test2\Original+Report.xlsx”);

OoxmlSaveOptions xlsxSaveOptions = new OoxmlSaveOptions();

xlsxSaveOptions.ExportCellName = true;

workbook.Save(@“e:\test2\outSavedFile.xlsx”, xlsxSaveOptions);
6

Thank you. This worked well.