Content options panel

This panel includes options for customizing the format of the spreadsheet.

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 overwrite existing cells to keep the existing cells and write the new data to them. Select shift existing cells down to append the new rows to the top of the sheet, shifting down existing cells.
Write Header	Decide whether to use the first row as the header row in the output spreadsheet. Select to use the first row of cells as the header row names for the output spreadsheet. Clear to keep the first row formatted as is.
Write Footer	Decide whether to use the last row as the footer row in the output spreadsheet. Select to use the last row of cells as the footer row names for the output spreadsheet Clear to keep the last row formatted as is.
Auto size columns	Decide whether the columns should automatically resize to fit the content. Note that auto-sizing is not a feature directly supported by .xls and .xlsx file formats, so results may vary. Select this option to auto-size columns to fit the content. To ensure the most accurate column-width calculations when using the auto-size feature, install the appropriate fonts on your server environment. Clear this option to maintain column width, despite content size.
Retain NULL values	Decide if null values in a cell are retained when reading.- Select this option to keep the null values. Clear this option to replace the null values with empty strings.
Force formula recalculation	Decide whether you want the step to attempt to update all the formula fields in the output file. When 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 selected for the .xlsx file format, the step attempts to recalculate the formula fields; however, 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. Select this option to force the step to update all the formula fields in the output file. Clear this option to keep the formula fields as is and not update them.
Leave styles of existing cells unchanged	Decide whether you want the step to set the style of existing cells being written, which is useful when writing to pre-formatted template sheets. Select this option to leave the style information of existing cells unchanged. Clear this option to overwrite the style of existing cells.
Extend data validation range	Decide whether you want to extend the validation range when performing Data Validation in the template.- Select this option to validate data up to and including the last row written. Clear this option to use the normal validation.