Export to Excel and CSV

Good day,

I need some help I am trying to export the data-grid to excel and csv, it does export the grid but the problem it only exports the current page. So i want to know how can I make it export the whole data in the data grid and not only the current page .

Thank you in advance

Usually the export will export all data, not the current page only: