Saving Excel File in XLSX(2007) Format Issue

Aspose.Cells Product Family
1

Hi All,

I am using the Aspose.Cells 4.5 in application and generated in the format of XLSX(2007). I am able to open the file here in India. But my client in Latin America Can't open the file.

Note : I don' want update the Version, Because it will impact many application

Please attacthed the error Screen shot.

Thanks

Naveen T

2

Hi,

I’d like to request you to share with us the code you used to generate the Excel file. It would be great if you could send us the source and resultant Files too.

3

Hi Naveen,

In some previous versions of Aspose.Cells, radix
point char of local settings has been used rather than ‘.’ when saving the xlsx files and as per our initial understanding, that might have caused this problem when local settings are changed. The later versions have fixed this problem.


You may download
the version 4.9.0. and try using it. You can access it from

http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx



Please send us the error file if you still find any problem.

4

Hi Salman,

Below is the Code which we are using to load the data to excel file.

Dim license As New Aspose.Cells.License
license.SetLicense("C:\Aspose.Cells.lic")
ExcelApp.Worksheets.Add()
ExcelSheet = ExcelApp.Worksheets(0)
ExcelSheet.Cells.ImportDataTable(dsExcelData, True, 0, 0)
ExcelApp.Worksheets.RemoveAt("Sheet4")
ExcelApp.Save(FileName, Aspose.Cells.FileFormatType.Excel2007Xlsx)

Thannks & Regards,

Naveen T

5

Hi Naveen,

Please try using the version 4.9.0 as shared in previous post or send us the workbook which is causing the problem.