Creating cell headers at specific cells #3028

New Issue

CharanGIS · 2023-11-16T16:46:31Z

CharanGIS commented

2023-11-16 16:46:31 +00:00

Could someone please point me on how I can add headers and values at specific cell? Could someone point me to the direction of where i can find the property/method of doing so?
I'm trying to achieve an excel file like below:

Could someone please point me on how I can add headers and values at specific cell? Could someone point me to the direction of where i can find the property/method of doing so? I'm trying to achieve an excel file like below: ![image](/attachments/2a10ab69-6e1b-4a28-a18c-fc39853c860a)

image.png

12 KiB

sheetjs commented

2023-11-16 17:23:19 +00:00

https://docs.sheetjs.com/docs/api/utilities/array include a few examples using sheet_add_aoa and sheet_add_json to build up more complex layouts.

The "Multi-table Export Example" from https://docs.sheetjs.com/docs/api/utilities/html#add-to-sheet is similar to your ask.

The sheet_add_ family methods accept an origin argument which specifies where cells should be written.

If you would like more guidance, share sample JSON data and a sample output.

https://docs.sheetjs.com/docs/api/utilities/array include a few examples using `sheet_add_aoa` and `sheet_add_json` to build up more complex layouts. The "Multi-table Export Example" from https://docs.sheetjs.com/docs/api/utilities/html#add-to-sheet is similar to your ask. The `sheet_add_` family methods accept an `origin` argument which specifies where cells should be written. If you would like more guidance, share sample JSON data and a sample output.

sheetjs closed this issue

2023-11-16 17:23:19 +00:00

Sign in to join this conversation.