cells source code:
src.zip (1.6 KB)
origin excel:
南都成都工厂CSR审核问题清单-SCAR201911110013.xlsx.zip (8.0 KB)
converted problem:
error.jpg (157.3 KB)
Please have a check.
cells source code:
src.zip (1.6 KB)
origin excel:
南都成都工厂CSR审核问题清单-SCAR201911110013.xlsx.zip (8.0 KB)
converted problem:
error.jpg (157.3 KB)
Please have a check.
I tested your scenario/ case using your sample code with your template file and found an exception “java.lang.NumberFormatException: For input string: “preserve”” when loading the file. I got the exception on the line of code:
Workbook excel = new Workbook(new FileInputStream(sourceFile), loadOptions);
Could you confirm if you got the same exception or your issue is different? After your confirmation, we will log a ticket for it for evaluation and investigations.