Excel Export: Table Functionality
Excel Export: Table Functionality
![cmdControl](https://secure.gravatar.com/avatar/2d086017a9601aad25e0703458abe38f/?default=https%3A%2F%2Fvanillicon.com%2F2d086017a9601aad25e0703458abe38f_200.png&rating=g&size=120)
I am importing a table and would like to export it into an excel file in table format (ie format the data in the excel sheet as a table for table functionality, such as header, sorting, etc).
How do I go about this?
Thank you
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
The Buttons extension for DataTables has the ability to export to Excel files. Example.
Allan
@allan I was not clear. I am using excelHtml5 to do export data from a table to an excel file; thanks to the forums, I was able to even export data from several tables to individual sheets into a single excel file.
My issue is to format the exported data in the excel file into a excel table format with all the bells and whistles, such as those you see in the image below.
I see what you mean - I'm afraid that's beyond the scope of what the Excel export button is attempting to do. You'd need to use a proper Excel abstraction library to build such a spreadsheet.
Allan
Thank you for the reply, Allan. Appreciate all the help!
(As a side note, why do you have a signature as your name when we know its your name bc you posted it? lol)
Its not a signature - I write it each time. I treat forum posts a lot like letters where I sign off with my name![:) :)](https://datatables.net/forums/resources/emoji/smile.png)
Allan