In this article I will explain with an example, how to export ASP.Net Table to Excel file using jQuery.
The ASP.Net Table will be exported (converted) to Excel file using the jQuery table2excel plugin.
 
 
HTML Markup
The HTML Markup consists of an ASP Table and an ASP Button.
<asp:Table ID="tblCustomers" runat="server">
    <asp:TableHeaderRow>
        <asp:TableHeaderCell>Customer Id</asp:TableHeaderCell>
        <asp:TableHeaderCell>Name</asp:TableHeaderCell>
        <asp:TableHeaderCell>Country</asp:TableHeaderCell>
    </asp:TableHeaderRow>
    <asp:TableRow>
        <asp:TableCell>1</asp:TableCell>
        <asp:TableCell>John Hammond</asp:TableCell>
        <asp:TableCell>United States</asp:TableCell>
    </asp:TableRow>
    <asp:TableRow>
        <asp:TableCell>2</asp:TableCell>
        <asp:TableCell>Mudassar Khan</asp:TableCell>
        <asp:TableCell>India</asp:TableCell>
    </asp:TableRow>
    <asp:TableRow>
        <asp:TableCell>3</asp:TableCell>
        <asp:TableCell>Suzanne Mathews</asp:TableCell>
        <asp:TableCell>France</asp:TableCell>
    </asp:TableRow>
    <asp:TableRow>
        <asp:TableCell>4</asp:TableCell>
        <asp:TableCell>Robert Schidner</asp:TableCell>
        <asp:TableCell>Russia</asp:TableCell>
    </asp:TableRow>
</asp:Table>
<br/>
<asp:Button ID="btnExport" Text="Export" runat="server" />
 
 
Export ASP.Net Table to Excel using jQuery
Inside the jQuery document ready event handler, the Export Button has been assigned a jQuery Click event handler.
When the Export Button is clicked, the jQuery table2excel plugin is applied to the ASP Table and it is converted (exported) to Excel file.
The jQuery table2excel plugin accepts filename parameter which sets the name of the Excel file.
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="Scripts/table2excel.js"></script>
<script type="text/javascript">
    $(function () {
        $("[id*=btnExport]").click(function () {
            $("[id*=tblCustomers]").table2excel({
                filename: "Table.xls"
            });
            return false;
        });
    });
</script>
 
 
Screenshots
The ASP Table
Export HTML Table to Excel using jQuery in ASP.Net
 
Excel file being downloaded when Export Button is clicked
Export HTML Table to Excel using jQuery in ASP.Net
 
The generated Excel file
Export HTML Table to Excel using jQuery in ASP.Net
 
 
Browser Compatibility

The above code has been tested in the following browsers.

Internet Explorer  FireFox  Chrome  Safari  Opera 

* All browser logos displayed above are property of their respective owners.

 
 
Demo
View Demo
 
 
Downloads
Download Code