How to get the every data from table in pagination ?

middeugger

I need to export the data to Excel sheet. But when I export I get only the current page items . May I know how I get the whole data from every page when export ?

tangerine

See the FAQ.
https://datatables.net/faqs/#buttons

middeugger

@tangerine But the problem is I need to customize the sheet. They are getting the other page details, so may I know the code for doing the same in that buttons ?

colin

As you can see from this example, all rows are exported by default.

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin