This panel includes options for customizing how you want content to appear when it is written to an existing spreadsheet.
| Field | Description |
|---|---|
| Start writing at end of sheet (appending lines) (check box) |
Decide if you want the output to begin at the last defined row of the spreadsheet.
|
| Offset by ... rows | Specify any non-zero number to cause the step to move this amount of rows down (positive numbers) or up (negative numbers) before writing rows. Negative numbers may be useful if you need to append to a sheet, but still preserve a pre-styled footer. |
| Begin by writing ... empty lines |
Specify any positive number to cause the step to leave this amount of rows empty. When writing to an existing sheet, you may decide to write a few empty lines first. This option is useful if you want to append a few rows to an existing sheet, but offset them to see the bounds of each generated block of rows. |
| Omit header (check box) |
Decide if you want to include a header when writing to an existing spreadsheet. Omitting a header is useful if you want to generate new files with a header, but you do not want to repeat the header in subsequent runs where you append to the same file.
|