Id

String

No

Step identification string.

File Name

String

Yes

Name of the output file.

Sheet

Integer

No

Number of the sheet in file into which the data will be written (numbering is zero-based, so the first sheet is numbered 0). Ignored if sheetName is specified. Default value: 0.

Sheet Name

String

No

Name of the sheet in the file into which data will be written. Default value: the parameter sheet is used.

Overwrite File

Boolean

Yes

Specifies whether the existing output file will be overwritten. If set to false, data will be written to a new sheet of the existing file. Default value: true.

Clear Sheet

Boolean

Yes

Specifies whether the existing output sheet in the existing file should be cleared before filling it with input rows. If this parameter is not set and the output file and sheet contain some data, only a portion of cells (depending on startCell and the number of rows and columns in the input) will be overwritten. Ignored if overwriteFile is set. Default value: false.

Start Cell

String

Yes

Specification of the first row and column of the area of the sheet to be written. Use the traditional cell reference form [column letter][row number]. Default value: 'A1'.

Columns

List of Column Expr Def

No

A list of columns to be written to the database.

Write All Columns

Boolean

Yes

Specifies whether to write out all columns as defined in the input format. This attribute is exclusive to column definitions. If this value is set to on, then there must be no columns defined in the columns element, otherwise an error is reported.

Write Header

Boolean

Yes

Specifies whether to write the column's header to the output file. A header line is not written by default.

Date Format

String

No

Specifies an optional format for date values stored in the sheet. Use the format according to this specification (see the paragraph "Custom Number Formats". For example, "d.m.yyyy".) Default: the implicit format is used.