I am trying to use the Create Excel feature to create a multisheet workbook based on Multiple SQL exports.
Here is what I was trying to do
Execute SQL 1
Use StdOut as source for Excel Create file report.xlsx set sheet name to output1
Execute SQL 2
Use StdOut as source for Excel Create file report.xlsx set sheet name to output2

This leaves me a file that only has a sheet of output2

I then tried concatenate files taking two excel files to combine to a consolidated file
SQL1
StdOut to Output1.xlsx
SQL2
StdOut to Output2.xlsx
Concatenate files
- File mask *.xlsx
- Output to Combined.xlsx
(hoping for a Output.xlsx file with two worksheets of Out1 and Output2)
No luck

Any thoughts on how to achieve this?

It seems like you are overwriting the file. First use Excel - Create then Excel - Set.

---

Henrik,
Thanks for the quick reply as usual. When I choose task under Office I only have :
Excel - Get cell, Set Cell, Convert, Get Row Count, Create, ReCalculate, an Office Macro.
I am using Visual Cron 8.2.2.

Thanks
Matt

Use task: Excel - Set cell

The naming is not very intuitive, but you can use that to create the spread sheet in the first place. I'm not sure what benefit you have of Excel -Create.

Thanks I will give that a shot

That worked Jon.
Thanks for the clarification on that functionality.

Matt Peden