Currently I have a grid that groups on a specific column of the data. The display looks just as desired. A template is used to display the grouping "header" like

.ClientGroupHeaderTemplate("Title: #= ...  # <br/>Description: #=... # <br/>Author: #= ... # <span class='badge badge-light'>#= ... #/#= ...  #</span>");I 

The problem is that when exporting to Excel this "header" along with the associated HTML is exported as well. I would like to somehow disable these extra header lines from appearing in the exported data? As an added bonus I would also like to remove the duplicates from the exported data.

Thank you.

This works fine if all I am doing is removing rows but it seems to break when I combine showing and hiding columns like:

        static excelExport(e) {
            if (!Gartner.GlobalAgendaTabGrid.exportFlg) {
                e.preventDefault();
                e.sender.showColumn("Id");
                e.workbook.sheets.forEach(function (sheet) {
                    sheet.rows = sheet.rows.filter(r => r.type != "group-header");
                });
                Gartner.GlobalAgendaTabGrid.exportFlg = true;
                setTimeout(() => {
                    e.sender.saveAsExcel();
                });
            } else {
                e.sender.hideColumn("Id");
                Gartner.GlobalAgendaTabGrid.exportFlg = false;
           }
        }

The Excel file that is exported in this case ignores the filtering that I did to remove the rows and all the rows are included.

I noticed that you have two handlers. I am not sure how to specify this. Currently I have

        static excelExport(e) {
            e.workbook.sheets.forEach(function (sheet) {
                sheet.rows = sheet.rows.filter(r => r.type != "group-header");
            });
            // This code is performance intensive.
            if (!Gartner.GlobalAgendaTabGrid.exportFlg) {
                e.preventDefault();
                e.sender.showColumn("Id");
                Gartner.GlobalAgendaTabGrid.exportFlg = true;
                setTimeout(() => {
                    e.sender.saveAsExcel();
                });
            } else {
                e.sender.hideColumn("Id");
                Gartner.GlobalAgendaTabGrid.exportFlg = false;
            }
        }
This "deleted" rows still appear.

@(Html.Kendo().Grid<GlobalAgendaDashboardGridViewModel>()

.Name(gridName)
. . . .

.Events(events => events.DataBound("function(e) { Gartner.refreshFiltersForGrid('" + gridName + "'); Gartner.buildActionMenu(e);Gartner.GlobalAgendaTabGrid.onDataGridBound(e);}"
).ExcelExport("Gartner.GlobalAgendaTabGrid.excelExport"))

It seems that I am not calling the saCme handler that you are. Can you try to specify the attributes (mostly the handler) via the grid helpers?

Thank you.

Alex,

I have followed you example and got the output excel without the group header.

But in the excel, there is a blank column, first column.  Can you hide or delete this blank column from the excel output?

Hi, Michael,

The sheet contains a two dimensional array of rows and cells. So if you wanted to remove the first column, you would need to splice the first of each rows cells. There are many common ways of handling arrays so you can do it any way you prefer but here is one way:

 e.workbook.sheets.forEach(function (sheet) {
            sheet.rows = sheet.rows.filter(r => r.type != "group-header");
            $.each(sheet.rows, function(i,row){
                 // remove the first cell from each row
                  sheet.rows[i].cells.splice(0,1);
            });
           // remove the first column so it has the correct width 
            sheet.columns.splice(0,1);
            // update the filter range 
            sheet.filter = { from: 0, to: sheet.columns.length };
          });

In the previous example I shared, we were also hiding one column, so the filter is set to the columns.length -1 in it:

https://dojo.telerik.com/ekuDetoX

OOXML relevant API references:

• Cells - https://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook/configuration/sheets.rows.cells
• Columns - https://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook/configuration/sheets.columns
• Filter - https://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook/configuration/sheets.filter

Regards,
Alex Hajigeorgieva
Progress Telerik

Ding Ding Ding!

Thanks a lot