Not exporting complete data to excel from datatable
Not exporting complete data to excel from datatable
srtota
Posts: 5Questions: 1Answers: 0
I am using Datatable with pagination, am trying to export the data to excel by using "table2excel". But after export the excel is having only first page data not complete data .
This discussion has been closed.
Answers
Des it give you some advantage over the buttons excel DataTable extension? By his own description, pulls from the html table. When paging is turned on, only one page of html is attached to the table.
A work around is to change page length to "All", do the execel dump, then change it back. Unless you are working with large amounts of data, this should not be a distraction to the user.