NullPointerException when loading a CSV

Aspose.Cells Product Family
1

Description:
Getting NPE when loading a CSV.
Issue appear since 18.10

Stacktrace:
java.lang.NullPointerException
at com.aspose.cells.zcbg.a(Unknown Source)
at com.aspose.cells.zcbg.b(Unknown Source)
at com.aspose.cells.zcbg.a(Unknown Source)
at com.aspose.cells.zcbg.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)

Java:
String inputFilePath = “input.csv”;
TxtLoadOptions loadOptions = new TxtLoadOptions(LoadFormat.CSV);
loadOptions.setSeparator(’;’);
loadOptions.setConvertNumericData(false);
loadOptions.setConvertDateTimeData(false);
Workbook workbook = new Workbook(inputFilePath, loadOptions);
workbook.dispose();

CSV: input.zip (268 Bytes)

CSV content:
NUMBER;NUMBER_AS_TEXT;DESCRIPTION;DATE
123;1000001607725446;TOTO;'2015-01-16
123;1000001607725447.123;“456;789”;1977/12/25
245;-1000001607725438;; 22-09-2001

Regards,
Jean.

2

@jeankst,

Thanks for your query.

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42774 - NullPointerException when loading a CSV
3

@jeankst,

This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42774”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@jeankst,

Please try our latest version/fix: Aspose.Cells for Java v18.11.7:

aspose-cells-18.11.7.jar.zip (6.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

The issues you have found earlier (filed as ) have been fixed in Aspose.Cells for Java 18.12. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

6

Hi Aspose team,
I confirm issue has been fixed in both 18.11.7 and latest 18.12 releases.
Thanks,
Jean.

7

@jeankst,

Good to know that your issue is sorted out. 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.