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. Image for the cookie policy date

Export GridGrouping Control to Excel with header Names

Hi,

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

Thanks!!

9 Replies

AD Administrator Syncfusion Team February 23, 2007 02:44 AM UTC

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

Thanks!


AD Administrator Syncfusion Team February 27, 2007 03:49 PM UTC

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


GB Gokul B Syncfusion Team February 28, 2007 12:17 AM UTC

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


AD Administrator Syncfusion Team March 6, 2007 03:45 AM UTC

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


VA Valli Syncfusion Team March 6, 2007 06:59 AM UTC

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


AD Administrator Syncfusion Team March 6, 2007 02:34 PM UTC

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


GB Gokul B Syncfusion Team March 6, 2007 05:33 PM UTC

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


AD Administrator Syncfusion Team March 6, 2007 11:35 PM UTC

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!


VA Valli Syncfusion Team March 7, 2007 11:17 AM UTC

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

Loader.
Live Chat Icon For mobile
Up arrow icon