We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Export grid to excel slow performance

Thread ID:





44314 May 19,2006 02:54 PM Jun 14,2013 01:12 PM Windows Forms 2
Tags: GridControl
Lan Mo
Asked On May 19, 2006 02:54 PM

Hello There, I use following function code to export GGC context to excel. It takes 20 seconds to export 3033 rows with 10 columns grid. Attached is exported excel result. Any idea to tune up the code to make it faster? Thanks. public static void ExportToExcel(GridGroupingControl grid,string FileName) { IWorkbook myWorkBook = ExcelUtils.CreateWorkbook(1); IWorksheet sheet = myWorkBook.Worksheets[0]; Hashtable colIndexMapping = new Hashtable(); int count = grid.TableModel.ColCount; for (int i = 1; i < (count-1); i++) { GridColumnDescriptor cd = grid.Table.GetHeaderColumnDescriptorAt(i); if (cd != null) colIndexMapping[cd.Name] = i; } for (int i=0;i

Gaukhar Massabayeva
Replied On March 18, 2013 11:13 AM

Hi Ian, did you manage to get anywhere with this. I am having a similar problem.

Chris Bishop
Replied On June 14, 2013 01:12 PM

I am having a similar problem.  It is taking way too long to export 700 rows with 20 columns from a grid grouping control.  30 seconds to a 1minute.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.