We have added a new feature in the Excel output block that allows you to specify what action you want to take if you are publishing to an Excel worksheet that already exists.

You can choose from:

- Replace worksheet. This will delete the worksheet and replace it with a new worksheet every time you publish the data.

- Replace data, keep formatting. This will not delete the worksheet, but will instead delete all of the data inside the worksheet and replace it with the data you're publishing.

- Overwrite data, keep formatting. This will not delete the worksheet or the data, but will instead overwrite the data with the data your publishing. Any data outside of the published data range will be retained.

We have also added the ability to specify whether you want to write the headers and the position of the data (the top-left column/row).

The Replace data/overwrite data options allow you to create an Excel "template" file that contains the formatting (colours, fonts etc.) for the data you want to publish. When you publish to this worksheet the formatting will be retained after your data has been inserted.