CODEWITHSUNDEEP
javascriptnode.jsexceljs
Marquis
Marquis

Reputation: 192

Insert a column in exceljs

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

Upvotes: 4

Views: 8536

Answers (1)

Marquis
Marquis

Reputation: 192

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

Upvotes: 5

Related Questions