Javascript Download to excel sheet

Question

There is an HTML table as

<table>
       <tr><th>NAME</th></tr>
       <tr><td>SAL</td></tr>
       <tr><td>TOM</td></tr>
       <tr><td>SAM</td></tr>
       <tr><td>Jenny</td></tr>
</table>

Download to excel sheet

On click hyperlink how to save the table to excel sheet

score 3 · Answer 1 · answered Nov 07 '12 at 11:15

You might want to try using the XLSX.js lib http://blog.innovatejs.com/?tag=xlsx-js

There is an example there on how to export to excel which gives examples.

Note this exports to the XLSX format not XLS. But this should not be a problem for most use. The source is on GitHub: https://github.com/stephen-hardy/xlsx.js

score 2 · Answer 2 · answered Nov 16 '10 at 05:36

You may want to take a look at table2CSV, since Excel can open csv files with no problem (and as a bonus other software can do it too, like OpenOffice). If you need it to be cross-browser, there's no way of generating a downloadable file, for that you need a server side script like the one in the example in the page I linked.

score 1 · Answer 3 · edited Jan 18 '16 at 18:23

1

I have developed a product called scriptscraper which is designed to solve that problem.

Get the trial installed because the demonstration projects download data from yahoo finance and store the data in Excel. For that simple html table it would be no problem to do what you need.

edited Jan 18 '16 at 18:23

Zameer Ansari

28,977
24
140
219

answered May 09 '12 at 21:06

martsbradley

148
1
9

Correct me if I am wrong ... runs as a stand-alone Windows process, as opposed to something that could be referenced from any old HTML page and used to open up Excel on the local system? Also, it looks like it's 35mb, yikes. – GregT Jun 07 '12 at 23:06

score 0 · Accepted Answer · answered Nov 16 '10 at 05:27

0

Try this:

function makeSheet() {
var x = theTable.rows

var xls = new ActiveXObject("Excel.Application")
xls.visible = true
xls.Workbooks.Add
for (i = 0; i < x.length; i++){
  var y = x[i].cells
for (j = 0; j < y.length; j++){
     xls.Cells( i+1, j+1).Value = y[j].innerText
   }
  }
}

answered Nov 16 '10 at 05:27

switz

24,384
25
76
101

theTable is the id of the table is it?? – Rajeev Nov 16 '10 at 05:28
document.getElementById("theTable") – switz Nov 16 '10 at 05:29
Interesting, but it seems to works only with IE. I am looking for similar solutions for Firefox. – рüффп Jun 28 '11 at 15:19
2

@ruffp ActiveX runs only in IE. – undefined Nov 07 '12 at 11:16
Yes you are right, finally we choose another way by building the excel xml by using an xslt transformation instead using javascript (web publication was not a must have) – рüффп Nov 27 '12 at 19:37

Javascript Download to excel sheet

4 Answers4