I have an existing xlsx file, with 4 columns. [ A, B, C, D ]. I want to insert a new column between A and B to have => [A, B, C, D, E] where B is new and C, D, E are the old [B, C, D]. I haven't found a method in the doc page

Doc :

I have an existing xlsx file, with 4 columns. [ A, B, C, D ]. I want to insert a new column between A and B to have => [A, B, C, D, E] where B is new and C, D, E are the old [B, C, D]. I haven't found a method in the doc page

Doc : https://github./exceljs/exceljs

• javascript
• node.js
• exceljs

1 Answer 1

I found the method called "spliceColumns". It works perfectly. For my example => workbook.spliceColumns(2, 0, [])