I have a package that exports to an Excel template (i.e. a workbook that is created at runtime) which is working fine. However, it seems as though the template is created only on the first run of the package - subsequent runs populate the already existing
This leads to the problem of data populating starting at the row after the last row of the last export. I.e. if upon running the package once the data populates rows 1-100, running it again will populate data from rows 101-200 and so on.
Is there a way to either a) overwrite the existing workbook when exporting or b) preferably, set the workbook name dynamically at runtime based on a variable?