Definition

Specify how the leading and trailing white spaces in the fields should be trimmed. By default no data is trimmed, leaving all leading and trailing white spaces. This setting may also be overridden by the individual column settings.

Specify the value that should be written to the output file when any field in any row of the input RowSet has a null value. This value can be overridden by the individual columns.

Specify the row number (1 based) where the data should start. The default row number is after the title row or the headings row if they are present. When there is no title and no column headings, this defaults to 1 (the first row).

Specify the pattern to use for formatting the whole number fields (tinyint, smallint, int, bigint) in the output file. For e.g. ###,### (2,345). Please note that this setting will only be used if and only if there is at least one whole number (tinyint, smallint, int, bigint) type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern to use for formatting the decimal number fields (real, float, double, decimal and numeric) in the output file. For e.g. $###,###.00 ($2,345.46). Please note that this setting will only be used if there is at least one decimal number (real, float, double, decimal, numeric) type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern for formatting the date fields in the output file. For e.g. MM/dd/yyyy (08/02/2007). Please note that this setting will only be used if and only if there is at least one date type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern to use for formatting the time fields in the input files. For e.g. hh:mm:ss AM/PM (08:12:56 PM). Please note that this setting will only be used if and only if there is at least one time type column defined under this data element. This value can be overridden by the individual columns.

Specify the pattern to use for formatting the timestamp fields in the input files. For e.g. MMM dd, yyyy hh:mm:ss AM/PM (Aug 02, 2007 08:12:56 PM). Please note that this setting will only be used if and only if there is at least one timestamp type column defined under this data element. This value can be overridden by the individual columns.

Specify how the contents of the data cells should be aligned horizontally. This can be overridden on a specific column, if needed.

Specify how the contents of the data cells should be aligned vertically. This can be overridden on a specific column, if needed.

Specify the background color to use for all the data cells. Leaving this value blank indicates that no background color will be used. This can be overridden on a specific column, if needed.

Specify the font to use for the data. This can be overridden on a specific column, if needed.

Specify the size of the font to use for the data. This can be overridden on a specific column, if needed.

Specify the color of the data font. This can be overridden on a specific column, if needed.

Specify whether or not to apply bold style for the data. This can be overridden on a specific column, if needed.

Specify whether or not to apply italic style for the data. This can be overridden on a specific column, if needed.

Specify whether or not the strikethrough effect should be applied to the data. This can be overridden on a specific column, if needed.

Specify how the data cells should be underlined. This can be overridden on a specific column, if needed.

Specify whether or not the contents of the data cells should be wrapped. This can be overridden on a specific column, if needed.

Specify the orientation of the data cells. This can be overridden on a specific column, if needed.