asked on 12/6/2019

Export JSON data to Excel

Good Day Experts!

I am working on a project for my landscaping business and need a little bit of direction. It utilizes node/express/sequelize/mySQL. The user input saving to the database is working great. I have JSON data displaying based on user selection of search criteria. I have the JSON data exporting to a CSV file. I would like to format the heading and data rows so they look presentable. I am guessing I have to switch to creating an actual excel workbook.

I have been searching the net for how to achieve output to an excel workbook. Unfortunately, I have not had any success just trying to create an excel workbook. Could you point me the direction ?

Thanks,
jimbo99999

JavaScript JSON

Last Comment

Jimbo99999

7/9/2020

Noah

12/6/2019

Hi there! :)

I'm not sure since I need some data but you can try this converter as a start. It might be able to convert your data to look more presentable.

Reference: http://www.convertcsv.com/json-to-csv.htm

Norie

12/6/2019

jimbo99999

I've not tried it myself but perhaps you could take a look at exceljs.

ste5an

12/6/2019

hmm, I would use XML with an XSLT to HTML instead of CSV.

Jimbo99999

12/9/2019

ASKER

Hello

Thanks for the replies. I have been trying all 3 but not having any luck. I am going to circle back to the exceljs and try that again.

Jimbo99999

12/12/2019

ASKER

Well, I was able to get it working kind of.

If I have all of the spreadsheet generating code in my server.js file it works great. If I have 1) at the top of the server.js file and 2) behind the button click in my view.js file I get the error --> "Uncaught ReferenceError: Excel is not defined"

If I have 1) and 2) behind the button in my view.js file I get the error --> "Uncaught ReferenceError: require is not defined"

1) var Excel = require('exceljs');
2) var workbook = new Excel.Workbook();

Can you offer insight in what I am missing?

Thanks,
Ed

ASKER CERTIFIED SOLUTION

Norie

12/12/2019