linways / table-to-excel

Javascript library to create "valid" excel file from html table with styles
MIT License
226 stars 109 forks source link

Exporting Tables with Pagination #28

Closed Markseemus closed 5 years ago

Markseemus commented 5 years ago

Can this library export tables with pagination?

rohithb commented 5 years ago

No. It will only export HTML tables present in the DOM. Currently, it does not have an option to append table to an existing sheet. If you have a lot of data to be exported, I won't recommend using this library. Instead, create the excel file at the server and send it to the client. (if your back end is in JavaScript you can use exceljs/exceljs )

xlsx is a compressed file, so if you have large amount of data you can save a lot of bandwidth and the entire process will be much faster