Java, ListObject -> getListColumns -> Insert new column by index

[eyalmolad]

Hello, I am trying to manipulate the Excel file that has a table (ListObject).
Lets say I have a table with 10 columns and I want to add a new column at index 5. The new table would have 11 columns.

Is there an API for this? The only think I saw is:

table.getListColumns().add("col1");

This returns the index, but it will be added at the end of the table.

Thanks

[amjad.sahi]

@eyalmolad,

Please simply try to use Cells.insertColumn() method to insert your column at your desired location accordingly. Also, you need to use ListObject.resize() method to update its range/area accordingly.

[eyalmolad]

Thanks. The reason I tried the table.getListColumns().add("col1"); function is because of this:

Cells.deleteColumn in table 21.2 vs 21.3 version

Have the following code that was working in 21.2 Java Aspose.Cells version: The simply iterates over all worksheets. If there is a table on the worksheet (ListObject), it simply deletes the column at index 1. It is attentionally using the Cells.delete column API. This was working on 21.2 version. Once we upgraded to 21.3 version, the Cells.deleteColumn link throws and exception: Cannot read field “c” because “” is null Attached is the Excel file. for (Object obj : workbook.getWorksheets()) …

the cells.deleteColumn stopped working in 21.3.

[amjad.sahi]

@eyalmolad,

You are welcome. We have now logged appropriate ticket for your other issue you posted in the thread. You may follow up the thread for latest updates and for fix.