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. |