Fields panel

This panel includes Fields table for specifying the fields that are written to the Excel files. The Fields table contains the following columns:

Column	Description
Name	The name of the field.
Type	The data type of a field: String, Date, or Number.
Format	The Excel format to use in the sheet. Please consult the Excel manual for valid formats. There are some online references as well.
Style from cell	A cell in the Excel spreadsheet (letter column, number row) such as A1, B4, etc., to copy the styling from for this column. This value is usually a pre-styled cell in a template.
Field title	If set, this is used for the Header/Footer instead of the Kettle field name.
Header/Footer style from cell	A cell to copy the styling from for the Header/Footer (usually some pre-styled cell in a template).
field contains formula	Set to Yes if the field contains an Excel formula. You do not need to include the notation = before your field value.
Hyperlink	A field that contains the target to link to. Supported targets can be links to other Excel spreadsheet cells, website URL's, ftp's, email addresses, or local documents.
Cell comment (XLSX)	The XLSX format allows to put comments on cells. If you would like to generate comments, you may specify fields holding the comment and author for a given column.
Cell comment author (XLSX)	The XLSX format allows to put comments on cells. If you would like to generate comments, you may specify fields holding the comment and author for a given column.