How to Include or Exclude Hidden Columns in Widget Excel Exports

When working with grids that contain hidden columns, it is important to control whether these columns are included in exported Excel files. By default, hidden columns are excluded in the export.

Steps to Include or Exclude Hidden Columns in Excel Exports

To manage the inclusion of hidden columns in your Excel exports, follow these steps:

1. Access Properties:

   • Click the settings icon on the widget to open the Properties section.

2. Navigate to Export Settings:

   • Locate the “Export Settings” section within the Properties.
     
     

3. Adjust Export Settings:

   • To include hidden columns in the export, enable the “Include Hidden Column” checkbox.
   • To exclude hidden columns from the export, disable the “Include Hidden Column” checkbox.
     
     

By following these steps, you can customize the export behavior of your grid to suit your needs.

References

• How to export underlying data of the widget instead of summarized data.
• If a column is hidden at the data source level, can it still be accessed at the dashboard designer level.