All tokens contained in this report will be written to a Microsoft Excel file. Pictures cannot be added to this report. Each token will be reported in its own column. The values for each iteration are written in the same column, but in new rows. An example of the output of an Excel (Column Mode) report is shown in Figure 8.35.

 

 

 

Excel (Column Mode) Options dialog has four sections:

 

•Display Text

 

•Running Options

 

•File Options

This section (Figure 8.36) has two sub-sections:

 

oAppend Options

With the radio buttons, you can choose to:

▪Start with an empty file (do not append to existing data).

▪Combine the output with the data in an existing file. If you combine data from an existing file, FCS Express will join the Batch Processing output with the data that exists in the selected Excel file (.xls). The new data will be written to the same or to another worksheet based on the Worksheet Options (see below).

 

oOutput file options

With the radio buttons, you can choose to:

▪Append to the file being combined with (specified above). This option is only available when the Combine the output with the data in an existing file (see above) is selected. FCS Express will add the new data directly into the file being combined with.

▪Save to a new file. FCS Express will save the data (combined or not, based on the Append Options (see above)) into a new file (.xls). The file path and the filename can be defined (optionally using tokens). See Save Layout - File Options for a description of batch generated filenames.

 

Other options available in this sections are:

▪Ask for confirmation before overwriting an existing file

▪Create output folder if it does not exist

▪Open file after saving

 

 

 

 

 

•Worksheet Options

 

oWorksheet Options (Figure 8.37):

▪Use a new worksheet named. Data will be added to a new worksheet for which the name can be customized (optionally using a token) by the user.

▪Use an existing worksheet. The existing worksheet can either be the first worksheet of the workbook, or a worksheet with a specific name (the name can be defined by the user, optionally using a token).

 

oRow/Column Arrangement

▪radio buttons control whether iterations are exported as new columns or new rows within a document.

 

oRow Options and Column Options

Options allow users to define the position into the worksheet where FCS Express will start adding data. E.g.

▪Start at the first available row (or column)

▪Leave a specific number of rows (or columns) empty

▪Start at a specific row (or column)

 

oHeader Options

Allows FCS Express to automatically write the Field Label to the resulting Excel document. By default, this option is enabled.