Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Deasun
1825
WinGrid Exporting performance?s Ver16.1
posted

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 = Nothing
objExcelWB = Nothing

  • 12480
    Offline posted

    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://ko.infragistics.com/samples/windows-forms/grid/asynchronous-exporting

    Please let me know if you have any questions.