Hello Team,
I have an Excel template with a single worksheet that includes predefined colours, formatting, etc.
In version 2025.0, I’m trying to write my results into this template, but I want to output multiple worksheets within the same workbook using the same template. I’ve tried several approaches (both dynamic and manual), but they either fail or behave unexpectedly.
What I’m seeing is that only the first worksheet shows the designed template but no results, while the subsequent worksheets contain the results but lose the template formatting. Even when I set Remove Template Sheet if Unchanged to Yes, the first worksheet (the template sheet) is still present with no results filled in.
Does anyone know whether this is achievable in version 2025.0? If so, how should it be configured in the Excel Writer?
Kind regards
Thanks!