Category / Section
How to hide TreeGrid columns on Excel export file
1 min read
It is possible to display ‘n’ number of columns In TreeGrid, but the user may wish to hide some columns while exporting and this is possible in TreeGrid to hide specific columns in excel exporting by using the column visible property.
The below code example explains how to export TreeGrid in excel format by hiding a column.
CSHTML
@(Html.EJ().TreeGrid("TreeGridContainer") .ChildMapping("Children") .ToolbarSettings(tool => { tool.ShowToolbar(true); tool.ToolbarItems(new List<TreeGridToolBarItems>() { TreeGridToolBarItems.ExcelExport, }); }) //.. ) @(Html.EJ().ScriptManager())
C#
public void ExportToExcel(string TreeGridModel) { ExcelExport exp = new ExcelExport(); var DataSource = this.GetDefaultData(); TreeGridProperties obj = ConvertTreeGridObject(TreeGridModel); obj.Columns[3].Visible = false; //Hiding the fourth column exp.Export(obj, DataSource, "Export.xlsx", ExcelVersion.Excel2010, newTreeGridExportSettings() { Theme = ExportTheme.FlatSaffron }); }
You can also find a simple sample for exporting TreeGrid in excel format with a hidden column here.