renaming of header fields #2944

New Issue

1batu · 2023-05-16T06:46:41Z

1batu commented

2023-05-16 06:46:41 +00:00

let newHeaders = ['name', 'phone', 'email','childs'];
let worksheet = workbook.Sheets[workbook.SheetNames[0]];
worksheet['A1'] = { t: 's', v: newHeaders[0] };
worksheet['B1'] = { t: 's', v: newHeaders[1] };
worksheet['C1'] = { t: 's', v: newHeaders[2] };
worksheet['D1'] = { t: 's', v: newHeaders[3] };

If you set the header to zero from the settings, you will reach the solution.

let rowObject = XLSX.utils.sheet_to_json(workbook.Sheets[sheet], {
header: 0,
raw: false,
blankrows: false,
});

``` let newHeaders = ['name', 'phone', 'email','childs']; let worksheet = workbook.Sheets[workbook.SheetNames[0]]; worksheet['A1'] = { t: 's', v: newHeaders[0] }; worksheet['B1'] = { t: 's', v: newHeaders[1] }; worksheet['C1'] = { t: 's', v: newHeaders[2] }; worksheet['D1'] = { t: 's', v: newHeaders[3] }; ``` If you set the header to zero from the settings, you will reach the solution. ``` let rowObject = XLSX.utils.sheet_to_json(workbook.Sheets[sheet], { header: 0, raw: false, blankrows: false, }); ```

sheetjs commented

2023-05-16 07:06:50 +00:00

What is the question?

FYI: https://docs.sheetjs.com/docs/getting-started/example#clean-up-workbook shows a more natural approach for renaming headers if you want to mutate the worksheet:

XLSX.utils.sheet_add_aoa(workbook.Sheets[workbook.SheetNames[0]], newHeaders, { origin: "A1" });

What is the question? FYI: https://docs.sheetjs.com/docs/getting-started/example#clean-up-workbook shows a more natural approach for renaming headers if you want to mutate the worksheet: ```js XLSX.utils.sheet_add_aoa(workbook.Sheets[workbook.SheetNames[0]], newHeaders, { origin: "A1" }); ```

sheetjs commented

2023-05-21 04:13:56 +00:00

If you can clarify the question further, we can reopen the issue.

sheetjs closed this issue

2023-05-21 04:13:56 +00:00

Sign in to join this conversation.