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 GridGrouping Control to Excel with header Names

Thread ID:

Created:

Updated:

Platform:

Replies:

56970 Feb 22,2007 04:36 PM Mar 7,2007 06:17 AM ASP.NET Web Forms (Classic) 9
loading
Tags: GridGroupingControl
Administrator [Syncfusion]
Asked On February 22, 2007 04:36 PM

Hi,

Is there an easy way to export GridGrouping Control data to Excel? Also, add the header names from GGC to Excel.

Thanks!!

Administrator [Syncfusion]
Replied On February 22, 2007 09:44 PM

Please ignore.. I found the answer in the samples.

Thanks!

Administrator [Syncfusion]
Replied On February 27, 2007 10:49 AM

Hi,

Is it possible to export only the filtered data from the Grid Grouping Control to Excel using XLSIO? User does the filtering on the web.

example would be great!!

Thanks,

Rekha

Gokul B [Syncfusion]
Replied On February 27, 2007 07:17 PM

Hi Rekha,

Attached is the sample in which filtered records of GridGroupingControl is exported directly to the Excel.

Forum56970_GridToExcel.zip

Kindly download our sample and let us know if it helps.

Thanks for using Syncfusion products.

Regards,
Gokulkumar.B

Administrator [Syncfusion]
Replied On March 5, 2007 10:45 PM

Hi Gokulkumar,

I am getting this error:

Error 4 The type or namespace name 'GroupingGridExcelConverterControl' could not be found (are you missing a using directive or an assembly reference?)

What are the dll's that are needed for the GroupingGridExcelConverter?

Thanks for your help!

Rekha

Valli [Syncfusion]
Replied On March 6, 2007 01:59 AM

Hi Rekha,

To Export the GridGrouping Control data to Excel you should add the following references.

Syncfusion.GridConverter.Web
Syncfusion.XlsIO.Base

Please let us know if you have any further queries.

Thanks for your continued interest in Syncfusion products.

Regards,
Valli

Administrator [Syncfusion]
Replied On March 6, 2007 09:34 AM

Valli,

Thanks for your quick reply!

- Is it possible to set the headers names as Row headers in Excel without any pivot results row etc.

- and also add the Autofilter in Excel?

Since the data that is exported to Excel has all the headers as rows rather than Row Header in Excel, I am not able to add the Autofilter feature in Excel.

Attached Excel file has the data that has data exported thru the Code in the first sheet ("Output from code" sheet) and the data how I would like to have in the second sheet(Output Wanted).

Thanks!!


Sample119.zip

Gokul B [Syncfusion]
Replied On March 6, 2007 12:33 PM

Hi Rekha,

Here is my answer for your query.

1) We are not sure in your query. Would you like to Customize the column caption in Excel? If so, below code snippet will helps you.

//Modifies the GridGroup header name to Custom Header name
mySheet1.Range["A3"].Text = "MyText";

If this is not a case could you please update us.

2)We do not support to add the AutoFilter in Excel while Exporting.

Sorry for the inconvenience caused.

Let us know if you need any other queries.

Regards,
Gokulkumar.B

Administrator [Syncfusion]
Replied On March 6, 2007 06:35 PM

Hi Gokulkumar,

As shown in my previously attached file, the first worksheet shows how data is exported with all the group header section and pivot results section.

I donot want that header section and pivot section in exported to Excel (as shown in second Worksheet) . I ONLY want the Column header names and the "filtered" data exported to Excel.

- Regarding setting the Autofilter property in Excel. I am able to achieve this by setting the following:
sheet.AutoFilters.FilterRange = sheet.UsedRange;

Is this possible when you are only exporting filtered records?

Thanks for your help!

Valli [Syncfusion]
Replied On March 7, 2007 06:17 AM

Hi Rekha,

We can remove the 'Header Section' and 'Pivot Section' while exporting to Excel. We can make use 'DeleteRow' function which will help you to achieve the above functionality.

I have created a sample for the same and you can download it from the following link:

http://websamples.syncfusion.com/samples/Grid.Web/4.4.0.51/F-56970/main.htm

Please let us know if you have any other concerns.

Regards,
Valli

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.

;