Export tables within scroller data-tables to excel
Export tables within scroller data-tables to excel
firdauspgt
Posts: 1Questions: 1Answers: 0
Hi, Im Firdaus, a young webprogrammer from Indonesia. First, sorry if my English look so bad.
I was create a report page using datatables and included with scroller plugin. Its look normal, I can search the data through the search textbox and can scroll the data whatever I want to.
Next, I want to export the table into XLS format. So, I browse the Internet and got the tutorial how it work. I was do that, but I found an abnormal case. I was export the table with table2excel.js and it's normal til I open the generated file. I found the Header of the tables is missing (it's not appear, the cell was have 0 row-height in excell). I'm done with try to give "style='height : auto' inside the <tr> delimiters, but itsn't working. So, the question is, how I can repair this issue?
Thanks for your attention, and I really Hope you can help me. Thanks before and Happy coding..
Answers
Use the TableTools extension.
http://datatables.net/extensions/tabletools/