json_to_sheet not convert data as required #2888

New Issue

MohamedAli · 2023-02-21T14:14:24Z

MohamedAli commented

2023-02-21 14:14:24 +00:00

Hello ,
i try to convert data come from API as expected but it get with key called value not convert to json_to_sheet schema , can any one help me please ?

Hello , i try to convert data come from API as expected but it get with key called value not convert to json_to_sheet schema , can any one help me please ?

Screenshot 2023-02-21 at 4.09.55 PM.png

35 KiB

Screenshot 2023-02-21 at 4.10.21 PM.png

64 KiB

Screenshot 2023-02-21 at 4.09.43 PM.png

94 KiB

sheetjs commented

2023-02-23 23:38:23 +00:00

That is very weird -- can you share the original file?

sheetjs commented

2023-06-26 01:51:40 +00:00

This is potentially the same problem as #2972 . If the data had an object or array as a key, it would be passed to the worksheet object without inspection. Please try going back and flattening the object as described in #2972 (comment) .

This is potentially the same problem as https://git.sheetjs.com/sheetjs/sheetjs/issues/2972 . If the data had an object or array as a key, it would be passed to the worksheet object without inspection. Please try going back and flattening the object as described in https://git.sheetjs.com/sheetjs/sheetjs/issues/2972#issuecomment-10516 .

sheetjs closed this issue

2023-06-26 01:51:41 +00:00

Sign in to join this conversation.