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


Delete Column

Enter number of column to delete.


Set Number Format

Control the format of a number or date column.

  • Column(s): Enter column number(s) to be formatted
  • Format: Enter desired format