I have a problem with the DataTable Plugin: it generates the CSV file normally, but the XLS is blank. My code looks like this:
$(_fechamento_faturamento_bases.prps.tablePrevia).DataTable({
"bPaginate": true,
"bFilter": true,
"bInfo": true,
"bDestroy": true,
"bAutoWidth": false,
"bServerSide": false,
"scrollX": true,
data: json.data,
dom: '<"orientation">lBfrtip',
buttons: [
{
extend: 'csvHtml5', text: 'CSV'
},
{
extend: 'excelHtml5', text: 'Analitico Excel'
}
]
});
There is also an error when I open the file:
Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Equal expected. Line 1, column 1412995.