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

Quick way to export to excel?

Thread ID:





65249 Jul 25,2007 04:04 PM UTC Aug 2,2007 06:07 AM UTC WinForms 3
Tags: XlsIO
Navaneeth Rajkumar
Asked On July 25, 2007 04:04 PM UTC

Is there a way to efficiently export the data from a gridGroupcontrol to an excel sheet along with formatting, grouping(if any), summary rows(if any)..

currently I use
IWorkbook myWB = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = myWB.Worksheets[0];

GridTableCellStyleInfo si = this.grid.TableModel[row, col];

Then I get each cell and check the si.Formatted text to see if its a $ or a date or a price, etc... The I set the number format(if $) to the excel cell and do a .text = value..

This is very slow as my grid contains 5000 rows with 50-70 columns.. Is there a quick way to export?

Rajagopal [Syncfusion]
Replied On July 26, 2007 02:15 AM UTC

Hi Navaneeth,

Thanks for your interest in Syncfusion Products.

In our latest version (v5.1), we ship a sample called 'Excel Export' with our browser samples, that has these features implemented when exporting the gridgroupingcontrol to excel.

\\Syncfusion\EssentialStudio\5.1\Windows\Grid.Grouping.Windows\Samples\2.0\Serialization\Excel Export

Let me know if you have any other questions.

Have a nice time.

Navaneeth Rajkumar
Replied On July 26, 2007 03:51 PM UTC

I am using 4.4.. Is there a way to achieve this feature in 4.4?


Rajagopal [Syncfusion]
Replied On August 2, 2007 06:07 AM UTC

Hi Navaneeth,

We have added these features from our latest version. If you want this in the version 4.4, then you would have to derive the GridExcelConverterControl class and implement the GridToExcel method to add this feature. We will update you with a sample accordingly, that has this feature of exporting the formatting, grouping if any in gridgroupingcontrol to excel.

Thanks for your patience.



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