Question

How can I convert an Excel sheet to JSON data in JavaScript?

  • 19 December 2016
  • 3 replies
  • 11 views
G

3 replies

david_r
Rank
Userlevel 4

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.

redgeographics
Rank
Userlevel 5
Badge +25

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.

G

Thanks for sharing a useful information

Seo Expert

Reply


Community Stats

28,727
Posts
109,522
Replies
36,566
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.