Excel Report Options

 

IMPORTANT: Microsoft® Office Excel must be installed to write to Excel.

 

Choose a destination for the Excel report:

 

Save to a Local Destination

Saves your Excel Report to a local or network folder of your choice.

 

Excel output filename

Saved Excel options:

Data Options tab: (at least one Data option of Include frequencies, Include vertical percents, Include horizontal percents or Include constant percents must be selected):

 

Include frequencies (WinCross default)

Write frequencies to the Excel report.

 

Include vertical percents (WinCross default)

Write vertical percents to the Excel report.

 

Include horizontal percents (WinCross default)

Write horizontal percents to the Excel report.

 

Include constant percents (WinCross default)

Write constant percents to the Excel report.

 

Include table of contents (WinCross default)

 

 

Generate filtering column (WinCross default)

Creates a hidden column to use for filtering what rows display on the Excel report.

Expand filtering column - When selected the hidden filter column is no longer hidden and the user can then easily filter based off specific row.

 

Formatting Options tab:

 

Show significance indicators (WinCross default)

Show significance indicators on the Excel report.

 

Position of significance indicators, relative to the value

Choose from the following options:

Put all text for a row in a single cell (WinCross default)

Row text is written as a continuous line, preventing text wrapping to multiple cells.

 

Suppress all blank lines (WinCross default)

Suppress blank lines after significance testing items

Suppress blank lines after banners

The blank line that normally displays/prints between the banner and the first row of the table is suppressed.

 

Show  % sign on percents; set cell type to Percentage (WinCross default)

Displays the percent sign next to percents on all tables and formats the cell as a Percentage.

 

Hide  % sign on percents; set cell type to Number

Hides the percent sign next to percents on all tables and formats the cell as a Number.

 

Show or hide % sign as specified in Table Options

Displays the percent sign next to percents and formats the cell as a Percentage or hides the percent sign next to percents and formats the cell as a Number based on the Show percent sign (%) option of Setup|Tables|Table Options. This option gives you the flexibility of formatting the tables as specified in Table Options where you may want to display the percent sign on some times and suppress the percent sign on other tables.

 

Concatenate banner text that spans multiple columns (WinCross default)

Banner text that would normally span more than one cell in Excel is merged into one cell. See the example below.

 

 

Combine tables

Freeze banner

Insert page breaks

Maintains the WinCross page breaks in the Excel report.

 

Write table title to the left of the table

Freeze row text

Worksheet Options tab:

 

Create each table as a separate worksheet, one banner per workbook

The default file is named jobname.xlsx (or jobname.xls), however, you can create a new file name by entering the file name in the Excel file name field. A separate worksheet is created for each table. All worksheets are contained in the same workbook. Each worksheet is labeled by the table number (i.e. Table 1, Table 2, etc.).

 

If you are running the tables against multiple banners, a variation of this file naming scheme is used. For tables run against the first banner, the resulting filename remains the same as above. When the tables are subsequently run against additional banners, however, the workbook filenames become Excel file name_2.xlsx, Excel file name_3.xlsx etc.

 

For example, say you have table 1 and banners 2 and 4 for job name EXAMPLE-ASCII.job, and you want to create separate Excel worksheets. When the task is complete, WinCross will have named the files EXAMPLE-ASCII.xlsx (Excel file for banner 2) and EXAMPLE-ASCII_2.xlsx (Excel file for banner 4).

 

Create each table as a separate worksheet, all in one workbook

The default file is named jobname.xlsx (or jobname.xls), however, you can create a new file name by entering the file name in the Excel file name field. A separate worksheet is created for each table. All worksheets are contained in the same workbook. Each worksheet is labeled by the table number (i.e. Table 1, Table 2, etc.) regardless of the number of banners run. The tables run by the first banner are written first with each subsequent banner's tables being written next as separate worksheets within the same workbook.

 

Create all tables in one worksheet, one banner per workbook

The default file is named jobname.xlsx (or jobname.xls), however, you can create a new file name by entering the file name in the Excel file name field. The worksheet is labeled by the banner number (i.e. Banner 1). If multiple banners are being used, a workbook for each of the banners is created.

 

If you are running the tables against multiple banners, a variation of this file naming scheme is used. For tables run against the first banner, the resulting filename remains the same as above. When the tables are subsequently run against additional banners, however, the workbook filenames become Excel file name_2.xlsx, Excel file name_3.xlsx etc.

 

Create one banner per worksheet, all in one workbook (WinCross default)

The default file is named jobname.xlsx (or jobname.xls), however, you can create a new file name by entering the file name in the Excel file name field. Each worksheet is labeled by the banner number (i.e. Banner 1, Banner 2 etc.). When the Include table of contents option is selected with this option, there will be separate worksheets for each table of contents. For example, if tables for 3 separate banners (Banner 1, Banner 2 and Banner 3) are being written to Excel, the first worksheet will be named "Table of contents", the second worksheet will be named "Banner 1", the third worksheet will be named "Table of contents(2)", the fourth worksheet will be named "Banner 2", the fifth worksheet will be named "Table of contents(3)" and the last worksheet will be named "Banner 3".

 

Excel Interweave banner options

 

Report Options tab:

 

Plain output (no cell borders or colors)

Plain output produces an Excel report with no background colors and no cell borders. This is a quick and easy way to disable background colors and cell borders.

 

Note:

  • The Plain output option disables all Enhanced output options including background colors and cell borders.
  • If you would like to use cell borders but not background colors, you can choose the Enhanced output option and either use the Use Enhanced Text Report fonts and colors for Excel output option and choose the Clear All option using Setup|Job Settings|Enhanced Text Report or the Use custom colors option and choose the Clear All option to clear all background colors.
  • If you would like to use background colors but not cell borders, you can choose the Enhanced output option and select the Disable cell borders option from the Excel Border Options dialog.

 

Enhanced output (WinCross default)

 

Use Enhanced Text Report fonts and colors for Excel output

Uses the Job Settings|Enhanced Text Reports settings when writing the report to Excel.

 

Note: The Use Enhanced Text Report fonts and colors option uses the Background Colors selected in Setup|Job Settings|Enhanced Text Report.

 

Use custom colors (WinCross default)

 

Cell Borders (WinCross default)

Allows the selection of Excel Border Options for the Excel report. Cell borders are not applicable if your Output file type is Excel 97-2003 (.xls).

 

Disable cell borders

Select this option to set all border styles (Table border, Outside row border and Inside row border) to None.

 

Choose border style for the following:

Note: When the Table border is set to a selection other than None, the Excel report begins in Column "B". If you set the Table border to None, the Excel report begins in Column "A".

 

Decimal Place Options tab:

 

Frequency

Percent

Round the full-precision values saved to Excel to the number of decimal places displayed in the Excel report itself

 

 

 

 

 

Excel multi run Add Run / Delete Run

 

It is verycommon for a client to request multiple Excel runs of the same report with different options selected. Now, this can all be done in a single run of WinCross by using the Add Run feature.  

 

 

 

Related topics:

Run|Tables

Excel Interweave Banners