The Legacy Excel output Driver has the ability to Delete Data & Append as an output option for Excel files. This is useful to retain custom formatting and conditional formatting on a worksheet.
However, the new Excel Output Driver and Macro-Enabled Excel Driver do not have this option.
I think this would be very helpful for a lot of our business needs, as we still use Excel for a lot of our reporting needs. I know that Tableau is a very powerful tool for exactly this sort of situation, but we do not yet have any widespread adoption at our company.
Particularly, conditional formatting would be a fantastic option, as it would save a lot of post-run manual process.