export html-table with jquery

Question

I would like to export the content of a html table with javascript.

First I would walk through all TD-elements and collect the data to send it in one big POST-query to another PHP-Page, that generates CSV-Excel from it.

Or could I use another framework, that already includes this functionality?

http://stackoverflow.com/a/7588465/439171 – Italo Borssatto Nov 18 '13 at 13:37 — Italo Borssatto, Nov 18 '13 at 13:37

score 1 · Accepted Answer · answered Jun 18 '13 at 08:44

1

Here is a useful plugin that converts a table to CSV string.

answered Jun 18 '13 at 08:44

halilb

3,785
20
28

1

That page seems not be obtained anymore, I copied the source to github: https://github.com/rubo77/table2CSV – rubo77 Jun 19 '13 at 18:48

score 1 · Answer 2 · edited May 23 '17 at 12:29

window.open(MIMEtype, dataContainerItem) can be used to export the html table data directly from browser without making a server trip. But as per web standards it has some limitations and also we can't handle the output file name. Simple steps to do so are -

wrap your html table into a container (DIV).
pass the html content of this container(DIV) html to window.open along with MIME type.

ex.

window.open('data:application/vnd.ms-excel,' + encodeURIComponent( $('div[id$=divTableDataHolder]').html()));

You may refer- http://codepattern.net/Blog/post/jQuery-export-table-data-into-MS-Excel

and awesome details on its limitations at - Export to CSV using jQuery and html

score 0 · Answer 3 · answered Nov 18 '13 at 13:41

0

Use Data URIs and table2CSV:

var data = $table.table2CSV({delivery:'value'});

$('<a></a>')
    .attr('id','downloadFile')
    .attr('href','data:text/csv;charset=utf8,' + encodeURIComponent(data))
    .attr('download','filename.csv')
    .appendTo('body');

$('#downloadFile').ready(function() {
    $('#downloadFile').get(0).click();
});

answered Nov 18 '13 at 13:41

Italo Borssatto

12,895
6
58
81

TableCSV has some bugs and is not developed any more, but there is another fork: https://github.com/ZachWick/TableCSVExport that already implemented some more new features (emptyValue, showHiddenRows, rowFilter) – rubo77 Nov 18 '13 at 14:28

export html-table with jquery

3 Answers3