Export GridGrouping Control to Excel with header Names

[Administrator]

Hi,

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

Thanks!!

[Administrator]

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

Thanks!

[Administrator]

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]

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]

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]

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]

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]

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]

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]

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