XLS Export Column Enhancement

This feature enhances the Enhanced Workbench Table Export feature so that the XLS export option now honors the current table view - including the current set of visible columns and the order the columns are displayed. 

In the example below, the first Export is run following the Screen Set/original view of the Table.

Export Table - Screen Set View

The Excel export, below, provides all the columns above in the same order as they are displayed above.

Excel Export - No Personalization/Column Changes

In the example below, the Configure Results and Columns features are used to personalize the table - changing the order of the columns and hiding a set of columns.

Configure Results - Reorder Columns

Hide Columns

With the Configure Results and Columns changes, the personalized table view is below.

Personalized Table View

When Export is run against the personalized table above, the Export now reflects the personalized view - column order and columns visible.

Excel Export - Personalized

This feature provides a consistent data export experience between the Excel and Unformatted Excel available options..

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

The UI Logic Configuration default for the Export Format is the Excel format - as shown below.

UI Configuration Export Format Parameter