Excel Export: Table Functionality
Excel Export: Table Functionality
cmdControl
Posts: 11Questions: 3Answers: 0
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
Allan