Load scientific notation value as numeric in Datatable

Aspose.Cells Product Family
24

@siddhanntarora1992,

Yes, this seems to be expected. For your information, both scientific notations and DateTime values are stored as numeric values in Excel format. Could you provide sample excel file, we will test the scenario/ case to try to sort it out.

25

Test.zip (6.9 KB)

Hi PFA @Amjad_Sahi

26

@siddhanntarora1992,

Thanks for the file.

I tested your scenario/ case using the following sample code with latest version/fix using your attached file, it works as expected:
e,g
Sample code:

 Workbook workbook = new Workbook("e:\\test2\\test.xlsx");
            Cells cells = workbook.Worksheets[0].Cells;

            DataTable dt = new DataTable();
            dt.Columns.Add("column1", typeof(double));
            dt.Columns.Add("column2", typeof(string));
            dt.Columns.Add("column3", typeof(double));
            dt.Columns.Add("column4", typeof(double));

            //.............
            ExportTableOptions options = new ExportTableOptions();
            options.SkipErrorValue = true;
            options.DataTable = dt;
            options.ExportAsString = true;
            options.Indexes = new int[] {0,1,2,3};

            cells.ExportDataTable(1, 0, 4, 4, options);

            Worksheet worksheet1 = workbook.Worksheets[workbook.Worksheets.Add()];
            worksheet1.Cells.ImportData(dt, 0, 0, new ImportTableOptions() {});

            workbook.Save("e:\\test2\\out1.xlsx");

Hope, this helps a bit.