Author Topic: Export all columns  (Read 1609 times)


  • Pro Deluxe
  • Newbie
  • *
  • Posts: 27
    • View Profile
Export all columns
« on: November 04, 2016, 02:40:06 am »
I have a ParamQuery table with a few columns, and local filters.
The export button takes the same columns that are being displayed in the table into Excel, but I want to know if it is possible to select a complete different set of columns.
I would like to igonore one of the columns in the table (I am rendering links that I don't want in Excel) and I want to add the rest of the columns that are in the database, so the user would get the entire table, but still using the filters they selected in the table.

Please let me know if that is possible.

Thank you!



  • Administrator
  • Hero Member
  • *****
  • Posts: 6178
    • View Profile
Re: Export all columns
« Reply #1 on: November 04, 2016, 09:47:40 pm »
It can be done by

switching the colModel ( containing different set of columns ) before export

and restoring it back to original colModel after export.