xxxxxxxxxx
//import this lib in your html
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.16.9/xlsx.full.min.js"></script>
//the use this function
function exportTableToExcelXlsx(tableID = 'data-table-responsive', filename = '') {
var tableSelect = document.getElementById(tableID);
var ws = XLSX.utils.table_to_sheet(tableSelect);
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
XLSX.writeFile(wb, filename || 'excel_data.xlsx');
}
xxxxxxxxxx
$( document ).ready(function() {
$(".export").click(function() {
var export_type = $(this).data('export-type');
$('#data_table').tableExport({
type : export_type,
escape : 'false',
ignoreColumn: []
});
});
});
xxxxxxxxxx
view source
1
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
2
<script src="src/jquery.table2excel.js"></script>
xxxxxxxxxx
view source
1
var options = {
2
fileName:"File Name"
3
};
4
Jhxlsx.export(tabularData, options);