Free Support Forum - aspose.com

NullPointerException using convertStringToNumericValue() when converting an HTML document to a Workbook

Aspose.Cells Product Family
,
#1

Hi Support Team,

Aspose Cells for Java version: 21.5.5

When converting an HTML table to a Workbook, calling cells.convertStringToNumericValue() and saving the workbook throws a NullPointerException, depending on the contents of certain cells.

This functionality was working fine in Cells for Java 21.3.

Workbook workbook = new Workbook("working.html");

Cells cells = workbook.getWorksheets().get("Sheet1").getCells();

cells.convertStringToNumericValue();

workbook.save("test.xlsx");

Attached is a zip file containing one working HTML file and one non-working HTML file:

aspose_html.zip (469 Bytes)

Note that the only difference between the two files is the contents of the first cell on the first row.

Any advice would be appreciated!

#2

@mclark,
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-43486 - NullPointerException when converting an HTML document to a Workbook
#3

@mclark,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

#4

Great! Many thanks :slight_smile:

#5

@mclark
Please try our latest fix:
aspose-cells-21.5.6-java.zip (7.3 MB)

#6

Works perfectly! Many thanks for the quick turnaround time :slight_smile:

#7

@mclark,

Good to know that the new fix fixes your issue. Feel free to contact us any time if you need further help or have some other queries or issue, we will be happy to assist you soon.

1 Like