Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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