We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Getting strange values as footer to imported data using JSONUtility (Java)

Hi,
I am getting some strange values being appended to the row immediately after last row for the inserted data. The data is inserted using the JSONUtility.

Below is an extract of the source code.

private void populateData(Worksheet worksheet, String jsonString) {
    worksheet.getCells().clear();
    // Import JSON data
    JsonLayoutOptions options = new JsonLayoutOptions();
    options.setArrayAsTable(true);
    JsonUtility.importData(jsonString, worksheet.getCells(), 0, 0, options);
}

I have attached a copy of a screen showing the strange fields e.g. affectedRows changedRows fieldCount, etc.

The additional of the strange fields causes the Excel file to become corrupt as I have a pivotable referencing the inserted data.

How do I hide / disable these fields?

Regards,

James

Screenshot 2020-07-09 at 17.45.06.png (29.4 KB)

PS I am using v20.6

@trackback,
You may share the template Excel file for our testing. It will help us to analyze the issue and provide assistance accordingly.