ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: sshede on November 20, 2020, 12:35:30 pm

Title: how to hide column on hit Excel export
Post by: sshede on November 20, 2020, 12:35:30 pm

 how to hide column on hit Excel export

Title: Re: how to hide column on hit Excel export
Post by: paramvir on November 20, 2020, 02:44:41 pm

Please use Columns().hide() API

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

Title: Re: how to hide column on hit Excel export
Post by: sshede on November 20, 2020, 04:31:32 pm

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

Title: Re: how to hide column on hit Excel export
Post by: paramvir on November 23, 2020, 09:51:33 am

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()