I want to add an export button that will export the data displayed in the table.

Adnan_MD

In my Laravel project, I am using the DataTables library. I want to add an export button that will export all the data in the table including all the pages(pagination)
as an Excel file.

kthorngren

I'm guessing you have server side processing enabled, ie serverSide: true. In this case the only rows at the client are those on the page and the export buttons are only able to access those rows to export. See this FAQ for options to export all rows using server side processing.

If this isn't the issue then please provide a link to a test case replicating the issue so we can help debug.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin