How can I export two rows in the tfoot of my table to Excel?
How can I export two rows in the tfoot of my table to Excel?
![yossel2](https://secure.gravatar.com/avatar/b5ddf4cef8109a8f9e012a8573ed85a2/?default=https%3A%2F%2Fvanillicon.com%2Fb5ddf4cef8109a8f9e012a8573ed85a2_200.png&rating=g&size=120)
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.
Replies
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