Datatables 1.10.8 Buttons excelHtml5 export bug

Datatables 1.10.8 Buttons excelHtml5 export bug

LorenzLorenz Posts: 2Questions: 0Answers: 0

The excelHtml5 Excel export doesn't work if there is no table footer.
The reason seems to be this code in buttons.html5.js:

if ( config.header ) {
   xml += addRow( data.footer );
}

It's also not possible to prevent this error by setting the "footer" option to "false" because it only checks for the "header" option. So this won't help:

buttons: [{
extend: 'excelHtml5',
footer: false
}]

When I set the "header" option to "false", it works. But of course the header is also not exported then.

Regards,
Lorenz

Replies

  • allanallan Posts: 64,032Questions: 1Answers: 10,555 Site admin

    Hi Lorenz,

    This was (is) a packaging error - sorry. There was a last second fix for exactly this issue. If you grab the latest files from the CDN that particular issue is resolved. I need to rebuild the DataTables package with that fix.

    Allan

  • LorenzLorenz Posts: 2Questions: 0Answers: 0

    Hi Allan,

    you're right, it works with the CDN version. Thanks!

    Lorenz

This discussion has been closed.