JQuery Exporting Table to Excel error when table has ID or Classes

Question

I am able to export an HTML table using jquery if the <table> does not have an ID or class:

But if my table has either an ID or a class attr the following jquery kicks out a string of html in one cell to excel:

$( "#clickExcel" ).click(function() { var dtltbl = $('#dtltbl').html(); window.open('data:application/vnd.ms-excel,' + $('#dtltbl').html()); });

I can get around this by removing the tables classes and ID, but that's not ideal. Anybody have a solution?

The whitespace is being removed so <td id='td1'> becomes <tdid='td1'>. Also <td>This has a space</td> becomes <td>Thishasaspace</td>. I don't know how to fix it, just thought I would add. This is a pretty neat trick if you can get it working! — Malk
– Malk, Commented Jan 24, 2014 at 0:56
@Malk: Yeah, the same thing happens with the <table> element, it turns into <tableid> which screws it all up. I have success with removing the ID and Class attr. Worse case I can wrap the table in a div, store the existing class and ID before deleting them, export it, then use the wrapped div to find the table and add the save ID and Classes back in, but damn thats ugly. — Ryan
– Ryan, Commented Jan 24, 2014 at 1:20
I think you need to encode your content: stackoverflow.com/questions/17142427/… — Tim Williams
– Tim Williams, Commented Jan 24, 2014 at 1:48

Sapikelio · Accepted Answer · 2015-12-16 10:17:14Z

I had the same problem as you and It has been solved this way:

$("#btnExport").click(function (e) { window.open('data:application/vnd.ms-excel,' +'<table>' +$("#YourTableId").html()+ '</table>'); e.preventDefault(); });

Hope It Helps

Georgi Diamandiev · Accepted Answer · 2016-09-30 09:22:20Z

You can encodeURI the string before opening it.

$( "#clickExcel" ).click(function() { var dtltbl = $('#dtltbl').html(); window.open('data:application/vnd.ms-excel,' + encodeURI($('#dtltbl').html())); });

Collectives™ on Stack Overflow

JQuery Exporting Table to Excel error when table has ID or Classes

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related