Hide column in Export to Excel.

Question

Hello.I would like to hide a column when exporting to Excel, but not hide it on the screen. It's possible?Regards.

Venkatesh Ayothi Raman · Answer

Hi Juan, 

Thanks for using Syncfusion products. 

We have achieved your requirement using column’s property of visible. Please refer to the following code example and Help documentation for more information, 




toolbarClick(args:any) { 
 
            switch (args.item.text) { 
                case 'Excel Export': 
                  let colLength: number =this.Grid.getColumns().length; //get the columns length 
                  let cols: any = this.Grid.getColumns(); //get the columns 
                  for(let i: number=0; i <colLength; i++ ){  
                  if(cols[i].field == "OrderID"){ 
                    cols[i].visible = false; //hidden the corresponding column before export 
                    this.Grid.excelExport().then(((e) => cols[i].visible = true)); //enable the corresponding column after export  
                    break; 
                    } 
                    } 
            } 
        } 

Help documentation: https://ej2.syncfusion.com/angular/documentation/grid/api-column.html?lang=typescript#visible 

Sample: https://plnkr.co/edit/NnCW24sEDOI3vK9VK8Gn?p=preview 


Please let us know if you have any further assistance on this. 

Regards,Venkatesh Ayothiraman.

Juan · Answer

Perfect!It works very well!Thank you very much!

Venkatesh Ayothi Raman · Answer

Hi Juan, 
 
Thanks for the feedback. 
 
We are very happy to hear that your requirement is achieved. 
 
 
Regards, 
Venkatesh Ayothiraman.