I am running a simple automated process that queries an OracleDatabase, sends the result set to Excel and then emails the Excelreport to end users. I would like to use Excels conditional formatting, or even some simple formatting in this Excel report. After updating the Excel report, all formatting is lost upon subsequent executions of the automated process.
Is there a way to preserve the formatting? Perhaps using an Excel template ?