How to export all rows in grid to excel


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.

AdvGridExcelIO vs 3.4.1
AdvGridRTFIO vs
DBAdvGrid vs
This post was helpful in resolving this issue for me.