Download excel file using jQuery with example
Download excel file using jQuery is very simple. You follow given bellow steps –
Step : 1 – Create HTML button to Download Excel file
<!DOCTYPE>
<html>
<head>
<title> Download Excel </title>
</head>
<body>
<p>
<input type="button" id="ExportButton" value="Click here to Download Excel" />
<p>
</body>
</html>Step : 2 – Add jquery.min.js and table2excel.js library in header section.
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="https://rawgit.com/unconditional/jquery-table2excel/master/src/jquery.table2excel.js"></script>
<script type="text/javascript">
$(function () {
/* button id 'ExportButton' */
$("#ExportButton").click(function () {
/* HTML table id 'tblListId' */
$("#tblListId").table2excel({
filename: "Data-Report.xls"
});
});
});
</script>Step : 3 – Add HTML Table in body section.
<table id="tblListId" cellspacing="0" width="100%">
<tr>
<th>Sr. No.</th>
<th>First Name</th>
<th>Last Name</th>
<th>Mobile No.</th>
<th>Address</th>
</tr>
<tr>
<td>1</td>
<td>Aman</td>
<td>Singh</td>
<td>1111111111</td>
<td>H.No.-E/125</td>
</tr>
<tr>
<td>2</td>
<td>Ashok</td>
<td>Singh</td>
<td>2222222222</td>
<td>H.No.-E/130</td>
</tr>
</table>Download excel file using jQuery with example