Html to Csv - large numbers getting converted into scientific notations

Aspose.Cells Product Family
1

Hi Team ,

I am using aspose cells to convert HTML to csv . Large numbers are getting converted into scientic notations - 6.92474E+12 .

I have tried - -
HtmlLoadOptions options = new HtmlLoadOptions();
options.setAutoFitColsAndRows(true);
options.setCheckDataValid(false);
options.setKeepPrecision(true);

but still output csv file contains data converted into scientific notations - 6.92474E+12 .

could you please help . I want to get large numbers as it is in output csv file,

2

@nvn16

Could you please zip and attach your HTML file, we will check and assist you to accomplish your task.

3

hi ,

please find attached file .

Thanks,
test.zip (22.8 KB)

4

@nvn16,

Please add a line to your code segment, it will work fine and as expected:
options.setConvertNumericData(false);

Hope, this helps a bit.

5

It worked . Thanks Amjad .

6

@nvn16,

Good to know that your issue is resolved by the suggested line of code. In the event of further queries or issue, feel free to write us back.