Export to Excel using jQuery

In this blog you will learn how to export to excel file using jQuery.

We will learn here how how to export data to excel using JQuery , In this article you can export Gridview data or html table data into excel.

Let's start now

Step 1: Design basic HTML table as in the following snippet to make sure that table should be present under DIV element and provide an ID to that DIV element.

<div id="content" style="width: 1200px; margin: 30px auto;">
    <table style="width:100%">
        <tr>
            <td>Jill</td>
            <td>Smith</td>
            <td>50</td>
        </tr>
        <tr>
            <td>Eve</td>
            <td>Jackson</td>
            <td>94</td>
        </tr>
    </table>
</div>
<input type="button" id="btn_excel" value="exportexcel"/>

Step 2 : Here comes the code to export the data into excel (jQuery).

$("#btn_excel").click(function(e) {
   window.open('data:application/vnd.ms-   excel,' + encodeURIComponent($('#content').html())); // content is the id of the DIV element
   e.preventDefault();
});

That's it with a single line of code we can export the data to excel.

I hope this helps u.
Happy coding!