User Guide

10.4.0
- 10.5.3
- 10.5.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Column

The Column Field Element allows you to specify the data parameters written to columns in an Excel file.

Field	Definition
Basic Tab
Index	Specify the index of the column in the input RowSet. The first column starts with index 1. Either index or name must be specified to customize the output data. If both index and name are specified, the index value will be used.
Name	Specify the name of the column in the input RowSet. The column names are case insensitive. Either index or name must be specified to customize the output data. If both index and name are specified, the index value will be used. The name specified here overrides the input RowSet column name.
Type Conversion Tab
Data Type	Specify the data type of this column. For e.g. integer, date or decimal. The data type specified here can be different than the actual data type in the input RowSet. If the data type is overridden, the task performs appropriate data type conversions when reading the data from the input RowSet. Default Value: Same as input data.
Pattern	Specify the pattern to use for formatting the data in this column. This will have effect if and only if the data type of this column is numeric, date, time or timestamp. The default pattern is taken from the parent Data element based on the type of this column. Default Value: Inherited from parent Data element.
Data Options Tab
Trim	Specify how the leading and trailing white spaces in this column should be trimmed. The default is inherited from the parent Data element. Default Value: Inherited from parent Data element.
Null Substitute	Specify the value that should be written to the output file when this column of the input RowSet has a null value. The default is inherited from the parent Data element. Default Value: Inherited from parent Data element.
Cell Format Tab
Horizontal Alignment	Specify how the contents of this column should be aligned horizontally. Default Value: general
Vertical Alignment	Specify how the contents of this column should be aligned vertically.
Background Color	Specify the background color to use for column.
Font	Specify the font to use for the data in this column.
Font Size	Specify the size of the font to use for the data in this column.
Font Color	Specify the color of the data font in this column. Default Value: Automatic
Bold	Specify whether or not to apply bold style for the data in this column. Default Value: false
Italic	Specify whether or not to apply italic style for the data in this column. Default Value: false
Strikethrough	Specify whether or not the strikethrough effect should be applied to the data in this column. Default Value: false
Underline	Specify how the data cells in this column should be underlined. Default Value: none
Wrap	Specify whether or not the contents of the data cells in this column should be wrapped. Default Value: false
Orientation	Specify the orientation of the data cells in this column.
Width	Specify how wide (number of characters) this column should be. Default Value: -1 (Auto sizes the column)