How can I export Excel files using JavaScript

Question

Is there any way to generate Excel CSV through Javascript    It should be browser compaatible too

User · Answer

I recommend you to generate an open format XML Excel file  is much more flexible than CSV  Read Generating an Excel file in ASP NET for more info

User · Answer

Create an AJAX postback method which writes a CSV file to your webserver and returns the url   Set a hidden IFrame in the browser to the location of the CSV file on the server   Your user will then be presented with the CSV download link

User · Answer

I recommend you to generate an open format XML Excel file  is much more flexible than CSV  Read Generating an Excel file in ASP NET for more info

User · Answer

Create an AJAX postback method which writes a CSV file to your webserver and returns the url   Set a hidden IFrame in the browser to the location of the CSV file on the server   Your user will then be presented with the CSV download link

User · Answer

Similar answer posted here   Link for working example  var sheet 1 data     Col One 1  Col Two 11    Col One 2  Col Two 22    var sheet 2 data     Col One 10  Col Two 110    Col One 20  Col Two 220    var opts     sheetid  Sheet One  header true   sheetid  Sheet Two  header false    var result   alasql  SELECT   INTO XLSX  sample file xlsx     FROM      opts  sheet 1 data  sheet 2 data       Main libraries required -    lt script src  http   alasql org console alasql min js  gt  lt  script gt    lt script src  http   alasql org console xlsx core min js  gt  lt  script gt

User · Answer

There is an interesting project on github called Excel Builder   js  that offers a client-side way of downloading Excel xlsx files and includes options for formatting the Excel spreadsheet  https   github com stephenliberty excel-builder js  You may encounter both browser and Excel compatibility issues using this library  but under the right conditions  it may be quite useful    Another github project with less Excel options but less worries about Excel compatibility issues can be found here  ExcellentExport js https   github com jmaister excellentexport  If you are using AngularJS  there is ng-csv  a  Simple directive that turns arrays and objects into downloadable CSV files

User · Answer

Create an AJAX postback method which writes a CSV file to your webserver and returns the url   Set a hidden IFrame in the browser to the location of the CSV file on the server   Your user will then be presented with the CSV download link

User · Answer

I recommend you to generate an open format XML Excel file  is much more flexible than CSV  Read Generating an Excel file in ASP NET for more info

User · Answer

If you can generate the Excel file on the server  that is probably the best way   With Excel you can add formatting and get the output to look better   Several Excel options have already been mentioned   If you have a PHP backend  you might consider phpExcel   If you are trying to do everything on the client in javascript  I don t think Excel is an option   You could create a CSV file and create a data URL to allow the user to download it   I created a JSFiddle to demonstrate  http   jsfiddle net 5KRf6 3   This javascript  assuming you are using jQuery  will take the values out of input boxes in a table and build a CSV formatted string   var csv          table   find  tr   each function          var sep             this  find  input   each function              csv    sep     this  val            sep                    csv      n         If you wish  you can drop the data into a tag on the page  in my case a tag with an id of  csv         csv   text csv     You can generate a URL to that text with this code   window URL   window URL    window webkiURL  var blob   new Blob  csv    var blobURL   window URL createObjectURL blob     Finally  this will add a link to download that data       downloadLink   html          lt a gt  lt  a gt     attr  href   blobURL   attr  download    data csv    text  Download Data    appendTo   downloadLink

User · Answer

Similar answer posted here   Link for working example  var sheet 1 data     Col One 1  Col Two 11    Col One 2  Col Two 22    var sheet 2 data     Col One 10  Col Two 110    Col One 20  Col Two 220    var opts     sheetid  Sheet One  header true   sheetid  Sheet Two  header false    var result   alasql  SELECT   INTO XLSX  sample file xlsx     FROM      opts  sheet 1 data  sheet 2 data       Main libraries required -    lt script src  http   alasql org console alasql min js  gt  lt  script gt    lt script src  http   alasql org console xlsx core min js  gt  lt  script gt

User · Answer

To answer your question with a working example     lt script type  text javascript  gt  function DownloadJSON2CSV objArray        var array   typeof objArray     object    JSON parse objArray    objArray       var str            for  var i   0  i  lt  array length  i              var line   new Array             for  var index in array i                line push       array i  index                             str    line join               str      r n             window open   data text csv charset utf-8     encodeURIComponent str       lt  script gt

User · Answer

If you can generate the Excel file on the server  that is probably the best way   With Excel you can add formatting and get the output to look better   Several Excel options have already been mentioned   If you have a PHP backend  you might consider phpExcel   If you are trying to do everything on the client in javascript  I don t think Excel is an option   You could create a CSV file and create a data URL to allow the user to download it   I created a JSFiddle to demonstrate  http   jsfiddle net 5KRf6 3   This javascript  assuming you are using jQuery  will take the values out of input boxes in a table and build a CSV formatted string   var csv          table   find  tr   each function          var sep             this  find  input   each function              csv    sep     this  val            sep                    csv      n         If you wish  you can drop the data into a tag on the page  in my case a tag with an id of  csv         csv   text csv     You can generate a URL to that text with this code   window URL   window URL    window webkiURL  var blob   new Blob  csv    var blobURL   window URL createObjectURL blob     Finally  this will add a link to download that data       downloadLink   html          lt a gt  lt  a gt     attr  href   blobURL   attr  download    data csv    text  Download Data    appendTo   downloadLink

User · Answer

I recommend you to generate an open format XML Excel file  is much more flexible than CSV  Read Generating an Excel file in ASP NET for more info

User · Answer

Create an AJAX postback method which writes a CSV file to your webserver and returns the url   Set a hidden IFrame in the browser to the location of the CSV file on the server   Your user will then be presented with the CSV download link

User · Answer

To answer your question with a working example     lt script type  text javascript  gt  function DownloadJSON2CSV objArray        var array   typeof objArray     object    JSON parse objArray    objArray       var str            for  var i   0  i  lt  array length  i              var line   new Array             for  var index in array i                line push       array i  index                             str    line join               str      r n             window open   data text csv charset utf-8     encodeURIComponent str       lt  script gt

User · Answer

There is an interesting project on github called Excel Builder   js  that offers a client-side way of downloading Excel xlsx files and includes options for formatting the Excel spreadsheet  https   github com stephenliberty excel-builder js  You may encounter both browser and Excel compatibility issues using this library  but under the right conditions  it may be quite useful    Another github project with less Excel options but less worries about Excel compatibility issues can be found here  ExcellentExport js https   github com jmaister excellentexport  If you are using AngularJS  there is ng-csv  a  Simple directive that turns arrays and objects into downloadable CSV files

[javascript] How can I export Excel files using JavaScript?

Examples related to javascript

Examples related to excel