Question
How can I convert an Excel sheet to JSON data in JavaScript?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Do you want to use Javascript to convert the Excel data to JSON, or do you want to convert the Excel data to JSON to use it in a Javascript module somewhere?
If it is the latter, you can let FME generate the workspace for you:
- Open FME Workbench
- File / Generate workbench...
- Reader: Excel, point it to your input Excel file
- Writer JSON, set your desired output filename
- Ok
Then run the workspace by pressing F5.
+62- Celebrity
Unless you have specific requirements as to what's supposed to happen to the data during that conversion, the Quick Translater should work just fine. Just select your Excel sheet as input and supply a path/filename for the JSON output file and that's it.