Microsoft Excel Output

Description

Microsoft Excel Output is a step in the Output Plugin for Process Studio Workflows. Microsoft Excel Output step can write data to sheets in one or more Excel files. This step can write to a Microsoft Excel 2003 spreadsheet file (xls). If you want to write to an xlsx file (Excel 2007 and above), you may use the Microsoft Excel Writer step. The Split option allows you to write to multiple files. The following sections describe the features available for configuring the Excel output step.

Configurations

No.	Field Name	Description
1	Step name	The name of this step in the workflow workspace.
2	Filename	The name of the spreadsheet file you are reading from.
3	Create Parent folder	If checked, the parent folder will be created.
4	Do not create file at start	If checked, does not create the file until the end of the step. This avoids creating empty files when no rows are in the data stream.
5	Extension	The three-letter file extension to append to the file name.
6	Include stepnr in filename	If you run the step in multiple copies (launching several copies of a step), the copy number is included in the file name, before the extension. (_0).
7	Include date in file name	Includes the system date in the filename (_20101231).
8	Include time in file name	Includes the system time (24-hour format) in the filename (_235959).
9	Specify Date time format	If checked, the filename will include a date and time stamp that follows the selection you choose from the drop-down box. Selecting this option disables the previous two options.
10	Date time format	Provide a specific date time format for the filename.
11	Show file name(s)	Displays a list of the files that will be generated. This is a simulation and depends on the number of rows that will go into each file.
12	Add filenames to result	Adds the filenames to the internal filename result set. This internal result set can be used later on, e.g. to process all created files.
	Content Tab:
1	Append	When checked, appends lines to the end of the specified file. If the file does not exist, a new one will be created.
2	Header	Enable this option if you want a header to appear before the spreadsheet grid data.
3	Footer	Enable this option if you want a footer to appear after the spreadsheet grid data.
4	Encoding	Specifies the text file encoding to use. Leave blank to use the default encoding on your system. To use Unicode, specify UTF- 8 or UTF-16. On first use, Process Studio searches your system for available encodings and populates this list accordingly.
5	Split every ... rows	After this many rows, start a new spreadsheet file to continue data output.
6	Sheet name	Specifies the name of the worksheet within the spreadsheet file.
7	Protect sheet?	If checked, enables password protection on the worksheet. You must also specify a password in the Password field.
8	Auto size columns	If checked, automatically sizes the worksheet columns to the largest value.
9	Retain NULL values	If checked, NULL values are preserved in the output. If un- checked, NULLs are replaced with empty strings.
10	Use temporary file	Sets whether a temporary file is used during the generation of the workbook. If not set, the workbook will take place entirely in memory. Setting this flag involves an assessment of the trade- offs between memory usage and performance.
11	Temporary files directory	Define the temporary files directory.
12	Use Template	If checked, PROCESS STUDIO will use the specified Excel template to create the output file. The template must be specified in the Excel template field.
13	Excel Template	Define the Excel template to use.
14	Append to Excel Template	Appends output to the specified Excel template.
	Custom Tab:
1	Header Font	Defines the Header Font details
2	Row Font	Defines the Row Font details
	Fields Tab:
1	Name	The name of the field.
2	Type	The field's data type; String, Date or Number.
3	Format	The format mask (number type).