iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
I have a webgrid that is displaying 165,000 rows. The grid returns the results in about 5 seconds. I exported the values in EXCEL using the built-in Export functionality, and I have been waiting for 15 minutes. Is there a limit to how many rows you can export at a time?
NOTE: I got an out of memory error after 20 mintues.
<LayoutSettings AllowAddNew="No" AllowColumnSizing="Yes" AllowColumnMove="Yes" AllowDelete="No" AllowEdit="Yes" AllowExport="Yes" AllowFilter="Yes" AllowGrouping="No" AllowSelectColumns="Yes" AllowSorting="Yes" GridLineColor="#CCCCCC" GridLines="Both" GridLineStyle="Solid" PagingMode="ClassicPaging" PagingSize="500" AllowBatchUpdate="true" PagingStyleUI="Slider" AllowMultipleSelection="No" GroupByBoxVisible="false" HeaderClickAction="SortMulti" VerboseEditingInformation="true" NewRowLostFocusAction="AlwaysUpdate" FocusNewRowOnLastCell="true" AllowColumnFreezing="Yes" ApplyFiltersKey="Enter" EditOnClick="True" AutoHeight="false" AutoWidth="false" AutoFilterSuggestion="true" PagingExportMode="ExportAllData" ShowFilterStatus="true" InProgressUIBehavior="ChangeCursorToHourGlass" ColumnFooters="Yes" HeaderWrapDefault="true" ColumnFooterAggregateMode="CalculateAllData" ShowColumnAction="true" PersistRowChecker="true" RestoreRowSelection="All">
protected void WebGrid1_Export(object sender, ExportEventArgs e) { e.ReportInfo.EnableValueList = true; }
I have this same problem.
I ended up having to stop the user from exporting this many records to the grid's built-in export formats and try to directly read the DataView of the DataSet and manually export to a format like CSV (streaming to disk).
I would love a long-term solution to exporting to Excel. Although I'm not sure Excel can handle more than 65K rows?
Mike
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname