Export array to excel xlsx in javascript

Question

There is one requirement in javascript to export the data (array or array of objects) to excel xlsx. I already exported the data to csv but unable to do same for xlsx. I tried many api from github so that I can used the libraries and export it to xslx but there are little help for it. I tried using stephen-hardy/xlsx.js, SheetJS/js-xlsx etc.

For exporting to csv I used this Click here! but the same cant be done for xlsx.

I tried xlsxwriter also to convert and write javascript array or array of object to xlsx but no result.

Now I m badly stuck because of the requirement. I also found out the similar post as of mine requirement Click here!

Please guys give me solution if any

Mike Gledhill · Accepted Answer · 2015-08-19 15:05:32Z

1

A while ago, I wrote the following article, which described how to export data from a jqGrid to a "real" .xlsx file:

Export jqGrid to Excel

This basically cached the jqGrid's data into a JavaScript variable, posted it back to a server, to save into Excel. The Excel file is created using the OpenXML libraries.

This should point you in the right direction.

Alternatively, you might like to try this library:

AlaSQL

(I haven't tried this though.)

answered Aug 19, 2015 at 15:05

Mike Gledhill

29.4k8 gold badges160 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3902443 · Accepted Answer · 2015-08-21 15:14:11Z

0

Try excelbuilderjs, I have done the same of downloading a Json Object with array of items into an excel sheet using this library.If you can please share the code on Jsfiddle, i can take a look at it and help you out

http://excelbuilderjs.com/

edited Aug 21, 2015 at 15:14

answered Aug 19, 2015 at 15:19

user3902443

391 silver badge6 bronze badges

1 Comment

Atiq Shaikh Over a year ago

var testdata = [ ["fruits","frozen","fresh","rotten"], ["apples",884,494,494], ["oranges",4848,494,4949], ["kiwi",848,33,33] ]; //This is my javascript array I want to export it to xlsx

Collectives™ on Stack Overflow

Export array to excel xlsx in javascript

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related