This is a migrated thread and some comments may be shown as answers.

Remove Some Rows in Code before Excel (HTML) Export

3 Answers 111 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dan
Top achievements
Rank 1
Dan asked on 24 Jan 2015, 09:25 PM
I am hoping someone can point me in the right direction.  I have a dataset displaying in my RadGrid.  When we export to Excel (HTML) I would like to remove some of the rows - based on a DataKeyValue.  How/where would I do this?

3 Answers, 1 is accepted

Sort by
0
Dan
Top achievements
Rank 1
answered on 25 Jan 2015, 05:15 PM
Here is what I found to work for me:

1. Set a variable when Exporting to Excel - I did this in the ItemCommand Event
2. Check this variable on ItemDataBound event
3. Pull the <tr> out like this: Dim row As TableRow = TryCast(e.Item, TableRow)
4. If you want the row to NOT show in Excel - add this: row.Style("display") = "none"
0
Kevin
Top achievements
Rank 1
answered on 26 Jun 2019, 06:05 PM

My export function look like

        static excelExport(e) {
            e.workbook.sheets.forEach(function (sheet) {
                for (var rowIndex = 1; rowIndex < sheet.rows.length; rowIndex++) {
                    if (sheet.rows[rowIndex].type == "group-header") {
                        const row = sheet.rows[rowIndex];
                        row.Style("display") = "none";
                    }
                }
            });
        }

I want to remove all of the group header rows. I am not sure how to find the Style for this row.

 

0
Attila Antal
Telerik team
answered on 01 Jul 2019, 04:10 PM
Hi Kevin,

I assume that the code you've shared is JavaScript and is trying to remove the ColGroups on client. It is a bit complicated to do that as the Grid renders multiple rows with multiple table header cells, where the rows might have rowsSpan and cells can have colspan applied.

I suggest using the server-side approach for eliminating the ColumnGroups from the exported file. 

Assuming the following structure:




Settings:

<ExportSettings OpenInNewWindow="true" IgnorePaging="true" ExportOnlyData="true">
    <Excel Format="Html" />
</ExportSettings>
<MasterTableView AutoGenerateColumns="False" DataKeyNames="OrderID" CommandItemDisplay='<%# !RadGrid1.IsExporting ? GridCommandItemDisplay.Top : GridCommandItemDisplay.None  %>' CommandItemSettings-ShowExportToExcelButton="true">
</MasterTableView>

ColGroups can be eliminated on the server using the following server-side code in the PreRender event of the Grid:

C# 

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (RadGrid1.IsExporting)
    {
        foreach (GridColumn col in RadGrid1.MasterTableView.RenderColumns.Where(x=> x.Visible))
        {
            col.ColumnGroupName = string.Empty;
        }
        RadGrid1.Rebind();
    }
}


VB

Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As EventArgs)
    If RadGrid1.IsExporting Then
 
        For Each col As GridColumn In RadGrid1.MasterTableView.RenderColumns.Where(Function(x) x.Visible)
            col.ColumnGroupName = String.Empty
        Next
 
        RadGrid1.Rebind()
    End If
End Sub

Result:



Kind regards,
Attila Antal
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Grid
Asked by
Dan
Top achievements
Rank 1
Answers by
Dan
Top achievements
Rank 1
Kevin
Top achievements
Rank 1
Attila Antal
Telerik team
Share this question
or