SheetJS json_to_sheet renaming headers

javascript sheetjs
Kay Singian picture Kay Singian · Sep 7, 2018 · Viewed 12.8k times · Source

I have an array of objects. By default, sheet_to_json uses object keys as headers. However, I need to rename those headers without explicitly modifying my array of objects.

Is this possible?

Answer

Peilin Zhai picture Peilin Zhai · Feb 24, 2020

replace the last line with below.

XLSX.utils.sheet_add_json(ws, data, {skipHeader: true, origin: "A2"});

Related questions

Format date with SheetJS

Thank you in advance for taking a look at this question! I am trying to use SheetJS to read a .xlsx file but am having some trouble with a column of dates that is formatted via Excel as Custom "yyyy/…

Read More
sheet js xlsx writeFile callback

I am trying to write multiple csv files from a set of data that I have loaded using the sheet js library. My first attempt was like: for (let i = 0; i < dataSetDivided.length; i++) { let exportSet = dataSetDivided[i] console.…

Read More
How to add cell border to SheetJS .xlsx generated file?

I have a SheetJS .xlsx generated file, but I have not been able to put border to the cells. I have this: And I need this: Is there a way to do it with SheetJS? It will be cool if …

Read More