How to export all rows in grid to excel

VCL TMS VCL UI Pack
1

Hi

 
Using the TDBAdvGrid and TAdvGridExcelIO components:
 
How to export all the rows to the spreadsheet?
 
it currently only exports the rows that are showing.
 
Thanks
 
kamran
2

Is this the latest version?
Try to toggle the property grid.DataSetType and if this fails, try to set grid.PageMode = false

3

The [ grid.PageMode = false ] is still need to export all of the records from the dbadvgrid.

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