Is it possible to export to excel the entire grid in case there is paging? How?
Varpi
FYI - This does not work.
We need to use UltraWebGrid XmlLoadOnDemandType = Virtual for displaying the grid on the page because there are many thousands of records. We want to be able to export all the records to Excel without having to render all of the records in the grid. How can this be done with UltraWebGridExcelExporter?
We need to set the following property for the grid
and on the button click write the following code
UltraWebGrid2.DisplayLayout.Pager.AllowPaging = False
UltraWebGrid2.DisplayLayout.LoadOnDemand = Infragistics.WebUI.UltraWebGrid.LoadOnDemand.NotSet
UltraWebGrid2.DataBind()
UltraWebGridExcelExporter1.DownloadName = "EmployeesAll.xls"
UltraWebGridExcelExporter1.Export(UltraWebGrid2)
UltraWebGrid2.DisplayLayout.Pager.AllowPaging = True
UltraWebGrid2.DisplayLayout.LoadOnDemand = Infragistics.WebUI.UltraWebGrid.LoadOnDemand.Xml
' Me.UltraWebGridExcelExporter1.Export(Me.UltraWebGrid2)
End Sub