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)