Good morning,
I have a wingrid with 74,464 rows and 21 columns.
Flat data no groupings or other bands. Was set to a dataview object. That's was filled from a Dataset object.
The dataset object only had that one Dataview in it.
The exporter takes approx. 1 minute and 47secs to export this to an xlsx doc on my C:\
My question is, is this on average slow, about right or fast?
Is there anything I can do to speed the export up?
Thanks
Code below:
Dim objExcelWB As New Infragistics.Documents.Excel.Workbook objExcelWB.SetCurrentFormat(Infragistics.Documents.Excel.WorkbookFormat.Excel2007)
Dim objExcWSTCMain As Infragistics.Documents.Excel.Worksheet
objExcWSTCMain = objExcelWB.Worksheets.Add(strDataTitle)
Dim strDataTitle As String = "Rpt_KPIs - Booked to Bill_RunBy_name.xlsx"
uwGridExporter.Export(uwGrid_NoIDX, objExcWSTCMain, 0, 0)
objExcWSTCMain = NothingobjExcelWB = Nothing
Hi,
I tried this out on a grid in my own sample and it took around 4 minutes to export. From this test, I'd say your export was pretty fast. I don't know of a way to speed the export up. If you would like to ensure that your application is responsive during the export, you may want to consider using the asynchronous export feature. You can read more about how to use this feature here: http://es.infragistics.com/samples/windows-forms/grid/asynchronous-exporting
Please let me know if you have any questions.