Microsoft Excel export options

You might need to set an access security setting in Excel before you can run the export: see Enabling security access for Microsoft Excel, Word, and PowerPoint exports.

You can export data in chart format. The export creates each chart on a separate worksheet immediately following the worksheet that contains the related table.

Select a chart type from the list. To use a custom chart that you have created in Excel, type in the name of the custom chart. To specify a chart template (Excel 2007 only), click Browse to select the desired file. For details of the way in which you can display data in charts, see Displaying results in charts.

The chart type you select is used only if you have not specified a chart type for a table using the Table Properties dialog on the View Tables tab.

The Excel worksheets that contain the tables are called T1, T2, T3, and so on. The worksheets that contain charts are called T1_ch, T2_ch, T3_ch, and so on, where T1, T2, and T3 are the names of the worksheets containing the tables to which they relate.

UNICOM Intelligence Reporter 7.5 and later exports tables by using Office Open XML.

If you want to export tables by using the Excel automation that was used in previous versions, select this option. Note that using the default, Office Open XML, is more reliable, faster, and avoids Microsoft Office licensing issues.

Select this option to hide Excel during the export. This makes the export faster.

Select if you want UNICOM Intelligence Reporter to open Excel and the file that contains the exported tables when the export is complete.

Check this box and enter a name and location for the output file, or click Browse to browse to the folder where you want to save it. If you do not specify a save location, and Launch after export is not selected, you are prompted to either launch the associated application or select a save location.

Click Advanced to view or edit the Advanced Excel Export Properties dialog.

Choose whether to use variable names or the more friendly descriptions for the variable texts in the tables.

Choose whether to use category names or the more friendly descriptions for the row and column headings in the tables.

Select this option if you want the tables to have borders in Excel.

Select this option if you want to export the headers and footers that have been defined for the table. When this option is selected, all of the headers and footers are displayed left aligned, regardless of the positions defined in the Header and Footer dialog. This has the advantage that they are easily visible in a wide table.

Select this option if you want headers and footers to be copied to the clipboard as formatted HTML.

When this property is set to False, the annotation is copied as plain text, so that all tags (except <br/>) appear in the Excel output. Set this option to False in a server environment.

This option controls the display of base rows and columns. If you leave this box blank, all rows or columns containing bases are suppressed for all tables, so that they are not displayed in the output file. If you check the box, rows and columns are displayed or hidden according to what is specified in the definition for each table.

Select this option to display the Status cell item value. This cell item is typically used to format the cell, but can also be displayed if this option is selected.

Select this option to use styles to control the formatting. By default, the exported tables will look the same whether you use styles or not. However, styles make it easy to change the look of your tables and apply standard formatting to multiple tables. If you want to use Excel to manipulate the data in the tables rather than printing them, you might prefer to export without using styles. For more information, see Exporting tables using Microsoft Excel styles.

Select this option to automatically change the width of the table columns to accommodate the width of the text. By default, this option is not enabled.

This option creates a TOC worksheet at the start of the workbook that contains information for each table including: Table Description, Filter Description, Export Status, Base, Folder, and links to the table and chart (if they are exported).

This option exports all the tables to an “All Tables” sheet, one after the other.

If a TOC or charts are included, they are exported to separate sheets.

This option controls the print option that will be selected in the Excel file. This does not affect how the tables appear in Excel. It affects how large tables appear when they are printed.

▪Repeat axes. Selects the Excel print option to repeat title rows and columns on every page so that when a table is split between more than one printed page, the table row and column headings are repeated on every page.

This option controls the display of significance letters for column proportion and column mean tests:

▪In separate row: The significance letters are shown in cells in the row after the cell items, as in the Results pane. This is the default value.

▪With first cell item: Significance letters are shown in the same Excel cell as the first cell item.

▪In separate column: Significance letters are shown in a separate column, headed by the significance letter for the column.

Export only the Percentage cell item.

Consistent with tables that include only the Column Percentages cell item, the Base rows display the counts when displaying only the percentages for the rest of the table. Conversely, when exporting only Row Percentages, the Base columns display the counts.

Select this option to put each type of cell contents in a separate table (all of the tables are on the same worksheet). This is useful if you want to perform calculations on the output or set up your own charts in Excel.