Hi,
Well, I think this is due the limitation of MS Excel related to CSV format. You can simply open your csv file into Ms Excel and then right- click to get Format Cells.. dialog box to, now convert to Numbers and you will get the same value retrieved by Aspose.Cells.
For you case if you need to get the exact scientific value you may try:
string filename = @"e:\test2\mbook.csv";
Workbook wb = new Workbook(filename, new LoadOptions(LoadFormat.CSV));
Worksheet ws = wb.Worksheets[0];
MessageBox.Show(ws.Cells["A1"].Value.ToString()); //5.7893E+49
Thank you.
Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us
