Postingan lainnya
print data di dalam div ke excel
ada yang punya tutorial print data di dalam div ke excel? tolong donk
0
4 Jawaban:
Jawaban Terpilih
html
.....
<table id="divData">
<thead>
<th>id</th>
<th>nama</th>
</thead>
<tbody>
<tr>
<td>1</td>
<td>budi</td>
</tr>
<tr>
<td>2</td>
<td>ani</td>
</tr>
</tbody>
<button id="ExportExcel" type="button" name="button">Export</button>
</table>
<script type="text/javascript">
$("#ExportExcel").click(function(e) {
var a = document.createElement('a');
//getting data from our div that contains the HTML table
var data_type = 'data:application/vnd.ms-excel';
var table_div = document.getElementById('divData');
var table_html = table_div.outerHTML.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
a.download = 'download.xls';
//triggering the function
a.click();
//just in case, prevent default behaviour
e.preventDefault();
});
</script>
ketika export hasil nya xlsx -> rename ke xls trus coba buka excelnya..
--- edit, -oowh div yah, aku mlah table..
0
mau tanya mas, kalau langsung generate jadi excel gimana? kalau contoh mas kan harus klik button dulu
0
$( document ).ready(function() {
var a = document.createElement('a');
//getting data from our div that contains the HTML table
var data_type = 'data:application/vnd.ms-excel';
var table_div = document.getElementById('divData');
var table_html = table_div.outerHTML.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
a.download = 'download.xls';
//triggering the function
a.click();
//just in case, prevent default behaviour
e.preventDefault();
});
1