Make data vertically instead of horizontally. #2866

New Issue

kieunam123 · 2023-01-27T07:25:54Z

kieunam123 commented

2023-01-27 07:25:54 +00:00

I need to convert an array of json object to workbook using the following data:

data = [{ 
    		"header1" : "detail1",
           	"header2" : "detail2",
        	"header3" : [{
                	"subheader1" : "subdetail1"
               		"subheader2" : "subdetail2"
            	 }]
         
       	}]

Expected result :

Is this possible? Thanks in advance.

I need to convert an array of json object to workbook using the following data: ``` data = [{ "header1" : "detail1", "header2" : "detail2", "header3" : [{ "subheader1" : "subdetail1" "subheader2" : "subdetail2" }] }] ``` Expected result : ![image](/attachments/d8129460-ac00-4a7d-8a2e-3b9074f81058) Is this possible? Thanks in advance.

image.png

6.5 KiB

sheetjs commented

2023-01-27 07:33:17 +00:00

Translate the data to the shape you need, then use aoa_to_sheet or json_to_sheet to pull data.

For example, using the literal names:

const massaged_data = data.map(({ header1, header2, header3: { subheader1, subheader2 }}) => ({
  header1,
  header2,
  subheader1,
  subheader2
}));
const ws = XLSX.utils.json_to_sheet(massaged_data);

https://docs.sheetjs.com/docs/getting-started/example includes a more involved example.

Translate the data to the shape you need, then use `aoa_to_sheet` or `json_to_sheet` to pull data. For example, using the literal names: ```js const massaged_data = data.map(({ header1, header2, header3: { subheader1, subheader2 }}) => ({ header1, header2, subheader1, subheader2 })); const ws = XLSX.utils.json_to_sheet(massaged_data); ``` https://docs.sheetjs.com/docs/getting-started/example includes a more involved example.

sheetjs closed this issue

2023-01-27 07:33:17 +00:00

Sign in to join this conversation.