There are two kinds of Infragistics exporters: UltraWebGridDocumentExporter, and UltraWebGridExcelExporter. The UltraWebGridDocumentExporter control has a property called DataExportMode. If you set this to AllDataInDataSource, it exports every record in the DataSet and not just what is displayed on the page. However, the control UltraWebGridExcelExporter doesn't have this property. It only exports one page at a time. So I followed the recommended solution to this problem:
http://devcenter.infragistics.com/Support/KnowledgeBaseArticle.aspx?ArticleID=6154
But this only exports about 50 records (out of over 6000). Why? Why does it decide how many records it wants to export?
Christian
Explore
I found this solution on another thread:
{
this.wg.DisplayLayout.Pager.AllowPaging = false;
wgxlExporter.Export(wg);
this.wg.DisplayLayout.Pager.AllowPaging = true;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
Can you post an example please?
I try
UltraWebGrid_consultation_article.DisplayLayout.LoadOnDemand = Infragistics.WebUI.UltraWebGrid.LoadOnDemand.NotSet; UltraWebGridExcelExporter1.DownloadName = "test.xls"; UltraWebGridExcelExporter1.Export(this.UltraWebGrid_consultation_article);
but no rows are exported
This problem was solved. A property on the grid must be set thusly:
LoadOnDemand="NotSet"
The article above does not mention this.