1) Writing html code below
<input type="button" id="btnExport" value=" Export Table data into Excel " />
<br/>
<br/>
<div id="vishare4all">
<table>
<tr>
<th>Column One</th>
<th>Column Two</th>
</tr>
<tr>
<td>row1 Col1</td>
<td>row1 Col2</td>
</tr>
<tr>
<td>row2 Col1</td>
<td>row2 Col2</td>
</tr>
<tr>
<td>row3 Col1</td>
<td>www.vishare4all.blogspot.com</td>
</tr>
</table>
</div>
2) Javascript code
$("#btnExport").click(function (e) {
window.open('data:application/vnd.ms-excel,' + $('#vishare4all').html());
e.preventDefault();
});
3) Writing the css code
body {
font-size: 12pt;
font-family: Calibri;
padding : 10px;
}
table {
border: 1px solid black;
}
th {
border: 1px solid black;
padding: 5px;
background-color:grey;
color: white;
}
td {
border: 1px solid black;
padding: 5px;
}
input {
font-size: 12pt;
font-family: Calibri;
}
Result will see like this:
02 June 2016
How to export data to excel using javascript?
Subscribe to:
Post Comments (Atom)
0 on: "How to export data to excel using javascript?"