Export HTML Table Data To Excel In PHP
Last Updated : Mar 11, 2024
IN - PHP HTML | Written & Updated By - Anjali
In this tutorial we will show you the solution of export HTML table data to excel in PHP, we all know that sometimes there is a table shown like a webpage showing how much tasks are done, etc.
In such websites, there is a button on click then covert your table data to excel form and download that excel file.
Hence, today we will learn about how to export html table data to excel in php. Let’s understand.
Step By Step Guide On Export HTML Table Data To Excel In PHP :-
As, there are many ways with the help of which we are able to export html table data to excel in php.
First of all, like there are some jQuery plugins and also manually codes in jQuery that you can write in your php file.
In this tutorial, we will learn about export html table data to excel in php with the help of jQuery plugins. And in next tutorial we will learn about manual codes. Let’s start.
<!DOCTYPE html>
<html>
<head>
<title>
Title of document is here
</title>
<script src=
"//ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js">
</script>
<script src=
"//cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js">
</script>
</head>
<body>
<table id="tableData">
<tr>
<th>ID</th>
<th>Name</th>
<th>Age</th>
</tr>
<tr>
<td>1001</td>
<td>john</td>
<td>20</td>
</tr>
<tr>
<td>1002</td>
<td>robert</td>
<td>25</td>
</tr>
<tr>
<td>1003</td>
<td>romio</td>
<td>50</td>
</tr>
</table>
<button class=’Btn’ onclick="tableToExcel(
'tableData', 'tableData’)">
Click to Export
</button>
<script>
or
$(document).ready(function () {
$(".Btn").table2excel({
filename: "Students.xls"
});
});
</script>
</body>
</html>
- Now, here first of all we create a basic structure of html. In this article we are going to export data form a webpage to excel.
- You can also get data from database with the help of php and can export in to excel. Hence, there are many ways with the help of this article can be done. Let us understand the codes below.
- First of all here we create a basic structure of html. If you don’t know about the basic structure of html. Then you can visit to our article in series of html, in which we show about the basic structure of html.
- Html is always or mostly written inside html tag which is a paired tag. In html most of html tags are paired tags. Now, under html we use head and body tags which are again paired tag.
- Under head tag we create title tag in which we show title of webpage. And link some additional scripts to help button to export data in excel files.
- Now, inside body here we create a table. We can also display data from database with the help of php. There is our already an article in which we show how to display data from database to webpage.
- Now, in the end we create a button and used some codes inside button. You don’t have to create thing complicated like that.
- Just create a button give it a class and id. And in script apply function with the help of jQuery. We hope that you understand this article properly.
Conclusion :-
At last in conclusion, here we can say that with the help of this article we are able to export html table data to excel in php. I hope this tutorial on export HTML table data to excel in PHP helps you.
About Anjali
