ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: Syreta on October 11, 2018, 07:16:22 pm

Title: Export Hidden Fields
Post by: Syreta on October 11, 2018, 07:16:22 pm

Hello,

some time ago, you told me to use the "copy" attribute for controlling if a column will be exported or not. But it seems, that this attribute is ineffective when attribute "hidden" is true.
Is there a way to export hidden columns to xlsx?

Thanks in advance,
Syreta

Title: Re: Export Hidden Fields
Post by: paramvir on October 11, 2018, 08:43:51 pm

Hidden columns are exported to xlsx as hidden columns.

Hidden columns can be made visible in Excel file by the user.

or

can be made hidden false in Excel workbook before exporting to Excel.

https://paramquery.com/pro/api/excel-workbook

or

Required columns in grid can be made hidden false in beforeExport event and hidden again in export event.