How can I export two rows in the tfoot of my table to Excel?

yossel2

Good morning, I have a table with two rows in the tfoot section. When I export it to Excel, it only shows one row. Is there a way to export both rows from the tfoot? I hope you can help. Thank you.

kthorngren

The latest version of buttons does support exporting multiple footer rows to Excel. See this test case:
https://live.datatables.net/sehiqisu/1/edit

But it requires Datatables 2.0.

Sounds like you are using an older version of buttons and Datatables. In this case you will need to use the customize option of the excel button to export multiple footer rows. You might be able to find an example on the forum of exporting either multiple rows in the header or footer. It won't be an easy task.

The choice is to either upgrade to DT 2.0.8 and buttons 3.0.2 or create the code needed in the customize function. Use the Download builder to get the latest code and read about DT 2.0 here.

Kevin