Desktop User Guides > Reporter > Publishing the results > Export Tables dialog > Microsoft Excel export options
 
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.
Display charts
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.
Use Excel Automation
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.
Hide Excel during export
Select this option to hide Excel during the export. This makes the export faster.
Launch Excel after export
Select if you want UNICOM Intelligence Reporter to open Excel and the file that contains the exported tables when the export is complete.
Save to file
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.
Advanced Excel Export properties
Click Advanced to view or edit the Advanced Excel Export Properties dialog.
Display properties
Variable
Choose whether to use variable names or the more friendly descriptions for the variable texts in the tables.
Category
Choose whether to use category names or the more friendly descriptions for the row and column headings in the tables.
Borders
Select this option if you want the tables to have borders in Excel.
Headers and footers
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.
Formatting for headers and footers
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.
Base values
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.
Status cell item values
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.
Chart options
See Chart options
Worksheet options
Use Excel styles
Select this option if you want 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 alter 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. See Exporting tables using Microsoft Excel styles for more information.
Printing
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. The options are:
Repeat axes. This 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.
Fit to page. This selects the "adjust to fit on one page" Excel printing option.
None. This does not select any printing options in Excel.
Show column statistics results with first cell item
This option controls the display of significance letters for column proportion and column mean tests. If you leave this box blank, the significance letters are shown in cells after the cell items, as in the Results pane. If you check this box, significance letters are shown in the same Excel cell as the first cell item.
Charts are not produced for tables with column proportion results shown with the first cell item.
Create a separate table for each cell item
Select this option if you want each type of cell contents to appear 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.
Wrap description text
Select this option if you want to wrap long descriptions onto the next line.
Auto-fit column widths
Select this option if you want to automatically change the width of the table columns to accommodate the width of the text. By default, this option is not enabled.
See also
Export Tables dialog