We have an excel template that is going out to clients. We'd like to use SSIS to export data into the template (that has headers) and still preserves the totals row which is at the bottom of the report (after the last row).
For example, if a client has one record and we import that one record into the template, the totals field will still be there and isn't "pushed off" the page.
But if another client has 80 records and we try to import those rows into the Excel template, the totals will be pushed off the first page.
Is there away for us to do this without having any code inside the Excel template?