Export HTML to Excel using JQuery

Question

that following code is working fine. but when i use <table width=100% id="tb"> like that, it wont work properly. why is that? it will export to excel but not in proper format. is there any way to get it correctly?

HTML:

<input type="button" id="btnExport" value=" Export Table data into Excel " />
<br/>
<br/>
<div id="dvData">
    <table>
        <tr>
            <th>Column One</th>
            <th>Column Two</th>
            <th>Column Three</th>
        </tr>
        <tr>
            <td>row1 Col1</td>
            <td>row1 Col2</td>
            <td>row1 Col3</td>
        </tr>
        <tr>
            <td>row2 Col1</td>
            <td>row2 Col2</td>
            <td>row2 Col3</td>
        </tr>
        <tr>
            <td>row3 Col1</td>
            <td>row3 Col2</td>
            <td><a href="http://www.jquery2dotnet.com/">http://www.jquery2dotnet.com/</a>
            </td>
        </tr>
    </table>
</div>

JS:

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

I checked your code and it is working at my end. Please check the php version at your end. In which browser are you testing this? — Ashish
– Ashish, Commented Mar 15, 2016 at 7:03
@Ashish i mean when i use <table> its working fine. bt if i use <table width=100% id="tb"> it will export to excel/ but not it proper format — tharinducs7
– tharinducs7, Commented Mar 15, 2016 at 7:16
@Ashish try this code by adding <table id="tb"> this and without adding this jsfiddle.net/lesson8/jWAJ7/light — tharinducs7
– tharinducs7, Commented Mar 15, 2016 at 7:19
The data URI needs to be URI encoded. window.open('data:application/vnd.ms-excel,' + encodeURI($('#dvData').html())); — Axel Richter
– Axel Richter, Commented Mar 15, 2016 at 7:48

Ashish · Accepted Answer · 2016-03-15 07:46:40Z

2

Try this:

window.open('data:application/vnd.ms-excel,' +  encodeURIComponent($('#dvData').html()));

Hope it helps.

edited Mar 15, 2016 at 7:46

answered Mar 15, 2016 at 7:37

Ashish

4982 gold badges8 silver badges24 bronze badges

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

1 Comment

tharinducs7 Over a year ago

Thank you very much. its working fine. but it wont show the excel cells. why is that? :)

Community · Accepted Answer · 2017-05-23 10:30:45Z

2

Source :Export HTML table to excel - using jQuery or Java

I would recommend Apache POI, we've been using it for years, never had any problems.

Alot of examples online to get a good start, and the documentation on the site is also good: http://poi.apache.org/spreadsheet/quick-guide.html

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Mar 15, 2016 at 7:39

REDEVI_

6948 silver badges18 bronze badges

Collectives™ on Stack Overflow

Export HTML to Excel using JQuery

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related