Create Excel - Workbook - VisualCron - Forum

Community forum

Matt Peden
2017-01-11T23:50:10Z
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?



Support
2017-01-12T07:41:01Z
It seems like you are overwriting the file. First use Excel - Create then Excel - Set.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Matt Peden
2017-01-12T14:57:35Z
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
Jon Tofte-Hansen
2017-01-12T15:21:47Z
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.
Matt Peden
2017-01-12T18:06:55Z
Thanks I will give that a shot
Matt Peden
2017-01-12T20:18:13Z
That worked Jon.
Thanks for the clarification on that functionality.

Matt Peden
Scroll to Top