We have a RadGrid with custom paging/sorting enabled. When exporting to Excel, only those rows currently visible in the grid are exported. We'd like to be able to export all of the rows in our data source without modifying the state of the grid (meaning the current page, page size, sort order, etc). I haven't been able to figure out a way to do this. Is this possible? If so, how?
3 Answers, 1 is accepted
0
csano
Top achievements
Rank 1
Rank 1
answered on 09 Feb 2008, 01:28 AM
Follow up:
http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/GeneralFeatures/Exporting/DefaultCS.aspx
In this example, only the first page is exported. Is there a way to export the contents of the other 10+ pages?
http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/GeneralFeatures/Exporting/DefaultCS.aspx
In this example, only the first page is exported. Is there a way to export the contents of the other 10+ pages?
0
Hello csano,
You can use RadGrid1.ExportSettings.IgnorePaging property to control if only the current page will be exported. In the example you pointed check the second checkbox and export the gird.You will get all the records exported. If you check in the code-behind, you will find this property controlled by the second checkbox.
Hope this helps.
Greetings,
Ves
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
You can use RadGrid1.ExportSettings.IgnorePaging property to control if only the current page will be exported. In the example you pointed check the second checkbox and export the gird.You will get all the records exported. If you check in the code-behind, you will find this property controlled by the second checkbox.
Hope this helps.
Greetings,
Ves
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
csano
Top achievements
Rank 1
Rank 1
answered on 11 Feb 2008, 08:29 AM
D'ohh. I don't know how I missed the text in the second checkbox in the example. Thanks for pointing that out.