Excel (XLSX) to CSV Conversion

hi i have a xlsx file of 80 90 MB.


i tried to convert into csv. i am able to convert…

the issue is:

20208637192 in excel is getting displayed as
2.02E+10

I want the csv to also have the exact same value as in Excel and not corrected value.

Thanks
Kapil

Hi,


Thanks for your posting and using Aspose.Cells.

Please note, if you will open your csv file in MS-Excel, it will display the number in scientific notation but if you will open it in Notepad, it will show you the number in its original form.

Please download and use the latest version: Aspose.Cells for Java (Latest Version), it is working fine. We have tested this issue with the following sample code. I have also attached the source excel file, output csv file and screenshot for your reference.

Java
Workbook wb = new Workbook(dirPath + “source.xlsx”);
wb.save(dirPath + “output.csv”);