jquery - Export array to excel xlsx in javascript - Stack Overflow

admin管理员组

文章数量:1391981

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

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

• javascript
• jquery
• arrays
• export-to-excel
• xlsx

Share Improve this question Follow edited May 23, 2017 at 12:29 CommunityBot 111 silver badge asked Aug 19, 2015 at 15:00 Atiq ShaikhAtiq Shaikh 111 gold badge11 silver badge22 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 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.)

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./

本文标签： jqueryExport array to excel xlsx in javascriptStack Overflow