Add multiple tables in the same sheet #2815

New Issue

mohannad.hanafi · 2022-10-20T11:26:05Z

mohannad.hanafi commented

2022-10-20 11:26:05 +00:00

Hello,
I have two arrays, each one of them represents a table

const firstTable = XLSX.utils.json_to_sheet(data)
const secondTable = XLSX.utils.json_to_sheet(statisticsData)

I want a way to add these two tables in the same sheet.

With an example please.

Hello, I have two arrays, each one of them represents a table ``` const firstTable = XLSX.utils.json_to_sheet(data) const secondTable = XLSX.utils.json_to_sheet(statisticsData) ``` I want a way to add these two tables in the same sheet. With an example please.

sheetjs commented

2022-10-20 15:04:54 +00:00

https://docs.sheetjs.com/docs/api/utilities#array-of-objects-input has an example:

/* Use shared header */
const header = [];
const ws = XLSX.utils.json_to_sheet(data, {header});
XLSX.utils.sheet_add_json(ws, statisticsData, {header, origin: -1, skipHeader: true});

https://docs.sheetjs.com/docs/api/utilities#array-of-objects-input has an example: ```js /* Use shared header */ const header = []; const ws = XLSX.utils.json_to_sheet(data, {header}); XLSX.utils.sheet_add_json(ws, statisticsData, {header, origin: -1, skipHeader: true}); ```

sheetjs closed this issue

2022-10-20 15:04:54 +00:00

abhiram11 referenced this issue

2023-02-26 02:09:11 +00:00

Pull Requests Fail CI/CD Tests #2894

Sign in to join this conversation.