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.
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.
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.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.