Excel to JSON through Indesign

Forum|Forum|3 years ago
June 8, 2022
2 replies
753 views

Hi,

Basically I am an Indesign script developer. I have an Excel content (attached), that content should be import into the Indesign Document. Excel document have multiple sheets. I have a code for import the JSON conent into the Indesign. So I plan to convert this Excel document into JSON and I will plan use my code to import the content into Indesign.
Can anyone help me to suggest Javascript code for convert the Excel to JSON.

Thanks
Asuvath

Doc1.xlsx

Scripting

This topic has been closed for replies.

Charu Rajput

Community Expert

Hello @Asuvath ,
May be you can try following if you are using the javascript.

https://stackoverflow.com/questions/27979002/convert-csv-data-into-json-format-using-javascript

Best regards

A

AsuvathAuthor

Known Participant

Hi Charu,

I have an excel document instead of CSV, so the script holding in the given link is not working for me. Can you please guide us bit more relavent to Excel to JSON conversion.

Thanks
Asuvath