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.

Excel Export from Grid is very slow

Thread ID:

Created:

Updated:

Platform:

Replies:

52412 Nov 28,2006 07:52 AM Nov 29,2006 03:02 AM Windows Forms 2
loading
Tags: GridControl
Boris Jansen
Asked On November 28, 2006 07:52 AM

Hallo!

I try to export my Grid into an Excelfile
by using the following function:

------------------------------------------------

Dim gecc As syncfusion.GridExcelConverter.GridExcelConverterControl = New Syncfusion.GridExcelConverter.GridExcelConverterControl

Dim saveFileDialog As SaveFileDialog = New saveFileDialog
saveFileDialog.Filter = "Files(*.xls)|*.xls"
saveFileDialog.DefaultExt = ".xls"

gecc.GridToExcel(Me.DataGrid.Model, saveFileDialog.FileName)

------------------------------------------------

There are 10 Rows and 20 Cols with Border, Color... The exportfuntion needs more than 30 second for exporting this small grid.

any idea to spead up your function? or is there an another way to export a grid to excel?

thanks for your help
Boris

Administrator [Syncfusion]
Replied On November 29, 2006 02:03 AM

Hi Boris,

We were not able to reproduce the issue here. Is it possible for you to upload us a sample or modify the attached sample to reproduce the issue here? This will help us to analyse the issue further.

Here is a sample.
GDBGExport.zip

Best Regards,
Haneef

Administrator [Syncfusion]
Replied On November 29, 2006 03:02 AM

Hi Haneef!

Thank you for this example prog. if i run
my or your application within my development studio the export needs more than 30 seconds.

after compiling the project and run the executable the export needs only 1 second. :-)

Regards,
Boris

>Hi Boris,

We were not able to reproduce the issue here. Is it possible for you to upload us a sample or modify the attached sample to reproduce the issue here? This will help us to analyse the issue further.

Here is a sample.
GDBGExport.zip

Best Regards,
Haneef

CONFIRMATION

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.

;