[Solved] Excel export: remove expand group column and command item template

[Richard Branham]

I have a grid which I export to Excel, but the Excel file contains a button for each of the groupings.  It also contains extra rows for a command item template.  I have as yet been unable to remove these before export.  Can anyone offer a suggestion as to how I can remove these?  A screen shot is attached.

[Daniel]

Hello Richard,

Please examine the following links:
RadGrid export overview
Word/Excel export (HTML-based)

Sample code:

<ExportSettings
   ExportOnlyData="true"
   HideStructureColumns="true" />

Let me know if the problem still persists.

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Richard Branham]

With the ExportSettings attributes set as requested, I get the same output.

[Richard Branham]

I was able to hide the extraneous items in the export by including the following code in grid_PreRender.  It's somewhat of a brute-force approach but it works.  (The _isExporting flag is set in the event handler for the button which initiates the export.)

            if (_isExporting)
            {
                GridItem[] groupHeader = grid.MasterTableView.GetItems(GridItemType.GroupHeader);
                foreach (GridGroupHeaderItem ghi in groupHeader)
                {
                    ghi.Cells[0].Text = "";
                }

                GridItem[] items = grid.MasterTableView.GetItems(GridItemType.CommandItem);
                foreach (GridCommandItem gci in items)
                {
                    gci.Visible = false;
                }
            }

[Sunny]

Richard,

I was able to fix the same problem with the below solution:

In the button click event set the value of the RadGrid property (GroupingEnabled) to false.

 

 

grid.GroupingEnabled = false;

-Ravi