DataTable Export to Excel with selected table?
DataTable Export to Excel with selected table?
M_A_K687
Posts: 1Questions: 0Answers: 0
Hi all,
i am using data table built-in extension for export datatable as excel which is working fine for export whole table now i want to export only selected column because some column having HTML entities (div,span, img ) inside table raw which causing issue.
i used following code for export whole table as excel
$(document).ready(function() {
$('#dashBoardTable').dataTable( {
"sScrollX": "200px",
"sScrollY": "200px",
"sDom": 'T<"clear">lfrtip',
// aaSorting: [['0', 'DESC']],
"sPaginationType": "full_numbers"
// "sAjaxSource": "sources/arrays.txt"
} );
} );
i am using data table built-in extension for export datatable as excel which is working fine for export whole table now i want to export only selected column because some column having HTML entities (div,span, img ) inside table raw which causing issue.
i used following code for export whole table as excel
$(document).ready(function() {
$('#dashBoardTable').dataTable( {
"sScrollX": "200px",
"sScrollY": "200px",
"sDom": 'T<"clear">lfrtip',
// aaSorting: [['0', 'DESC']],
"sPaginationType": "full_numbers"
// "sAjaxSource": "sources/arrays.txt"
} );
} );
This discussion has been closed.
Replies
http://datatables.net/extras/tabletools/button_options#mColumns