| Field | Description |
|---|---|
| Start writing at cell | Specify the cell in the MS Excel spreadsheet (letter column, number row) to start writing to in Excel notation, for example, A1. |
| When writing rows |
Specify how to write in new rows when the spreadsheet contains existing rows with data. Select one of the following options:
|
| Write Header (check box) |
Decide whether you want to use the first row as the header row in the output spreadsheet.
|
| Write Footer (check box) |
Decide whether you want to use the last row as the footer row in the output spreadsheet.
|
| Auto size columns (check box) |
Decide whether the columns should automatically resize to fit the content. Note that auto-sizing is not a feature that the XLS and XLSX file formats directly support, so results may vary.
To ensure the most accurate column-width calculations when using the auto-size feature, install the appropriate fonts on your server environment. |
| Force formula recalculation (check box) |
Decide whether you want the step to attempt to update all the formula fields in the output file. When this option is selected for the XLS file format, a flag is set
by the step. The formulas are recalculated as soon as the file is opened in MS
Excel. When this option is selected for the XLSX file format, the step itself
must attempt to recalculate the formula fields. The underlying POI
library does not support the full set of Excel
formulas, which may contribute to errors if the step cannot recalculate the
formulas.
|
| Leave styles of existing cells unchanged (check box) |
Decide whether you want the step to set the style of existing cells it is writing to. This option is useful when you are writing to pre-formatted template sheets.
|
This panel includes options for customizing the format of the spreadsheet.