Expanded Hierarchical Grid to Excel with Ignore Paging

[Claire Thomson]

I have a Hierarchical  grid which I want to export to Excel, this works fine but I would like to ignore the paging, but in doing so it will only print the details of the parent grid - am I missing something?

Thanks

[Daniel]

Hello Claire,

The expanded items will collapse automatically when RadGrid rebinds in order to fetch all items from your datasource (IgnorePaging)

For your convenience I attached a sample project that demonstrate how to persist the expanded items manually.

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.

[Claire Thomson]

Excellent thanks, that will come in handy if I need to remember which items were expanded!
I had to have all expanded at time of export - so my quick solution was

protected void Button1_Click(object sender, System.EventArgs e)
        {
            OrdersGrid.MasterTableView.HierarchyDefaultExpanded = true;
            OrdersGrid.PageSize = 100;
            OrdersGrid.MasterTableView.Rebind();

            foreach (GridDataItem item in OrdersGrid.MasterTableView.Items)
            {
                if (item.Expanded)
                {
                    foreach (GridTableView childTable in item.ChildItem.NestedTableViews)
                    {
                        childTable.ForeColor = System.Drawing.Color.Green;

                        foreach (GridHeaderItem header in childTable.GetItems(GridItemType.Header))
                        {
                            header.Visible = true;
                        }
                    }
                }
            }

            //ConfigureExport();

            OrdersGrid.ExportSettings.ExportOnlyData = true;
            OrdersGrid.MasterTableView.ExportToExcel();
        }