Using the TDBAdvGrid and TAdvGridExcelIO components:
How to export all the rows to the spreadsheet?
it currently only exports the rows that are showing.
Is this the latest version?
Try to toggle the property grid.DataSetType and if this fails, try to set grid.PageMode = false
The [ grid.PageMode = false ] is still need to export all of the records from the dbadvgrid.