Skip to content

How to import and export Excel files to javascript array

agershun edited this page Dec 28, 2014 · 4 revisions

How to import and export Excel files to javascript array?

Source: StackOverflow.com

Question

I'm currently looking for a fast and efficient way to import an Excel file into a javascript array, and export it also. I also need a way to do the same thing, but the opposite way.

Answer

Use:

    alasql('SELECT * INTO XLSX("myfile.xlsx",{headers:true}) \
                     FROM XLSX("srcfile.xlsx",{headers:true})');
Clone this wiki locally