Exporting html table to Excel isn't working

Question

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

This code keeps grabbing the html tags when I export, so in the excel doc it comes out as <table><tbody>.....

There is also this library excelbuilderjs.com. You might find it helpful. — Tasos K.
– Tasos K., Commented Mar 4, 2016 at 18:09

Community · Accepted Answer · 2017-05-23 11:45:02Z

1

You can't just set the content type to Excel format and then expect the code to convert itself to Excel.. You actually have to convert the HTML code to the required formatting of Excel.

Have a look at: How can I export tables to excel from a webpage

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Mar 4, 2016 at 18:01

Philip

2,9982 gold badges27 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Exporting html table to Excel isn't working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related