Author Topic: Export Hidden Fields  (Read 24 times)

Syreta

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 15
    • View Profile
Export Hidden Fields
« 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
« Last Edit: October 11, 2018, 07:18:32 pm by Syreta »

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3525
    • View Profile
Re: Export Hidden Fields
« Reply #1 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.