Insert a column in exceljs

Question

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.com/exceljs/exceljs

score 3 · Accepted Answer · answered Oct 20 '20 at 09:24

3

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

answered Oct 20 '20 at 09:24

Kalkal

161
3
14

do we need to commit the changes or the columns are removed directly after `spliceColumns`? – opensource-developer Dec 15 '20 at 14:13
If I remember well, it's already removed. To be sure, try to log the length of your columns :) – Kalkal Oct 26 '21 at 10:05

Insert a column in exceljs

1 Answers1