how to hide column on hit Excel export

[sshede]

 how to hide column on hit Excel export

[paramvir]

Please use Columns().hide() API

https://paramquery.com/pro/api#method-Columns

[sshede]

Thanks to replay but you can give me example. i want column hide in exls also

[paramvir]

Any columns hidden in the grid before method call to export to Excel are hidden in exported Excel too.

Example of Usage of Columns().hide():

Below code hides columns with dataIndx: 'ShipCountry' and  'ShipVia'

Code: [Select]

grid.Columns().hide({
    diHide: ['ShipCountry', 'ShipVia']
}
//now export to Excel.
grid.exportExcel()