Summary


This article describes Extensions available for Excel format outputs.



Add an Extension


  • Open the Excel Delivery
  • Select Add Extension
  • Select and configure an Extension
  • Select the Save button



Auto Filter

Add filter to column headers.
  • Row or Cell Range: Leave blank to apply filter to first row. Enter filter row number or row cell range (e.g. A1:C1)
  • Select Report Tab(s)/Select View(s): Select the tab(s) or view(s) to which the filter will be applied



Group


Add row grouping by column

  • Apply to sheets: Select the sheet(s) to which to apply the group function
  • First Row Headers: Un-check this option if the first row is not column headers
  • Group Column: Specify column on which to group values
  • Select Report Tab(s)/Select View(s): Select the tab(s) or view(s) to which the filter will be applied
  • Function requires the report table be positioned such that no space exists between the table and top and left edges page.

1074_006.png

.
Example of relative positioning in Web Intelligence:

1074_005.png



Auto Fit Columns


Auto-fit columns to cell contents. 

  • Select Report Tab(s)/Select View(s): Select the tab(s) or view(s) to which the filter will be applied



Freeze Panes


Freeze the position of select rows and/or columns.

  • Apply to sheets: Select the sheet(s) to which to apply the group function
  • Row: Enter row number

  • Column: Enter column number