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?

stackoverflow.com/a/7588465/439171

Italo Borssatto
– Italo Borssatto

2013-11-18 13:37:59 +00:00
Commented Nov 18, 2013 at 13:37 — Italo Borssatto
– Italo Borssatto, Commented Nov 18, 2013 at 13:37

halilb · Accepted Answer · 2013-06-18 08:44:57Z

1

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

answered Jun 18, 2013 at 8:44

halilb

4,1251 gold badge25 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rubo77 Over a year ago

That page seems not be obtained anymore, I copied the source to github: github.com/rubo77/table2CSV

Community · Accepted Answer · 2017-05-23 12:29:01Z

1

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

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Jul 18, 2013 at 16:14

Anil Kumar

1032 silver badges17 bronze badges

Comments

Italo Borssatto · Accepted Answer · 2013-11-18 13:41:44Z

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, 2013 at 13:41

Italo Borssatto

15.8k8 gold badges69 silver badges92 bronze badges

1 Comment

rubo77 Over a year ago

TableCSV has some bugs and is not developed any more, but there is another fork: github.com/ZachWick/TableCSVExport that already implemented some more new features (emptyValue, showHiddenRows, rowFilter)

Collectives™ on Stack Overflow

export html-table with jquery

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related