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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Export grid to excel slow performance

Thread ID:





44314 May 19,2006 06:54 PM UTC Jun 14,2013 05:12 PM UTC WinForms 2
Tags: GridControl
Lan Mo
Asked On May 19, 2006 06:54 PM UTC

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 03:13 PM UTC

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

Chris Bishop
Replied On June 14, 2013 05:12 PM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon