How can I export my entire dataset to Excel when I am enabling paging on my grid? I used the following line in my PDF Export, which seems to work fine.
Me.UltraWebGridDocumentExporter1.DataExportMode = UltraWebGrid.DocumentExport.DataExportMode.DataInGridOnly
Is there a similar functionality in the ExcelExporter?
Found the solution in another thread -
http://forums.infragistics.com/forums/p/2865/16661.aspx#16661
Thanks for sharing your solution in forums - this will certainly be useful for other developers.
Basically, from my experience, the rule is to rebind the grid explicitly with the option you need for exporting (e.g. turn paging off to export the whole grid), then export to file, and then rebind again to show the actual grid on page with what you need (you may want to set paging on again).