Inserting new column in existing xls file keeping the format intact In Java

Question

I want to insert a new column in between the existing columns of the excel which is in .xls format using Java retaining the existing format. Is there any api to do so?

Answer 1

You can use the Apache POI library to modify an Excel file.

Quick Guide: https://poi.apache.org/components/spreadsheet/quick-guide.html

You'll want to:

• Load your Excel file as a Workbook.
• Open the correct Sheet.
• Insert your new column using Sheet#shiftColumns.
• Save the modified Workbook back to an Excel file.