I have created a project that will select data from a table in an oracle DB and create an excel attachment and send it in an email.
The job worked great, until I attempted to use a template. I had some data manipulation in the template, creating percentages from the gathered rows, however when I ran the project the only thing attached to the email was the empty template.
When I created a generic template, with just every other line highlighted, the query populated cells on Sheet 2 of the spreadsheet, while sheet 1 contained the empty highlighted rows.
The documentation makes it seem easy and straightforward, so I must be doing something wrong. Any help is greatly appreciated.