Excel is a valuable feature for any web application. With jQuery, a popular JavaScript library, you can easily create a functionality that allows users to download data as an Excel file. In this tutorial, we’ll walk through the steps to achieve this with a practical example.
Prerequisites:
- Basic knowledge of HTML, CSS, and JavaScript.
- A text editor for writing code.
There is some few steps for one click download excel file in jquery. it is very simple and easy step please fallow my some simple example for this.
First You include some file like jquery.min.js and tableexcel.js in a footer
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
<script src="table2excel.js" type="text/javascript"></script>After that custom script include also in a footer.
<script type="text/javascript">
$(function () {
$("#export_data").click(function () {
$("#arvind_yadav").table2excel({
filename: "arvind_yadav.xls"
});
});
});
</script>and last step of example if you have table which is download content data of table then create own id like id=”arvind_yadav”.
Like this..
<table id="arvind_yadav" cellspacing="0" cellpadding="0">
<tr>
<th>Customer Id</th>
<th>Name</th>
<th>Country</th>
</tr>
<tr>
<td>1</td>
<td>Arvind Yadav</td>
<td>Uttar Pradesh</td>
</tr>
<tr>
<td>2</td>
<td>Praveen Kumar</td>
<td>India</td>
</tr>
<tr>
<td>3</td>
<td>Naveen Dev</td>
<td>France</td>
</tr>
<tr>
<td>4</td>
<td>Sanjay Schidner</td>
<td>Russia</td>
</tr>
</table>Now, if you open your HTML file in a web browser, you should see a table with sample data and a “Export to Excel” button. Clicking the button will trigger the download of an Excel file containing the table data.
