java.lang.NumberFormatException with SpreadsheetML -> PDF when converting numeric column

I’m getting the following exception when trying to convert a SpreadsheetML file to PDF format… probably because there’s a numeric defined column that has a comma-separated value. I could fix this probably by defining the column as a string type, but is this an issue?

at java.lang.Thread.run(Thread.java:745)Caused by: java.lang.NumberFormatException: For input string: “1,937”
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
at java.lang.Double.parseDouble(Double.java:538)
at com.aspose.cells.b.a.zp.a(Unknown Source)
at com.aspose.cells.zbel.e(Unknown Source)
at com.aspose.cells.zboz.a(Unknown Source)
at com.aspose.cells.zboz.j(Unknown Source)
at com.aspose.cells.zboz.a(Unknown Source)
at com.aspose.cells.zboz.a(Unknown Source)
at com.aspose.cells.zkn.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)

@imkookoo,

Please zip and attach your input SpreadsheetML file. We will check your issue soon.

Here is the sample file that is throwing that error:

CSKWWAKQTENC1JJGTFIF1325882578.excel.zip (11.1 KB)

Thank you,
Jay

@imkookoo
Please try the following codes:
LoadOptions loadOptions = new LoadOptions();
loadOptions.setCheckDataValid(true);
Workbook book = new Workbook(“D:/filetemp/CSKWWAKQTENC1JJGTFIF1325882578.excel.xml”,loadOptions);

Thanks Simon. That did the trick.

Best regards,
Jay

@imkookoo,

Good to know that your issue is resolved by the suggested code segment. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.