Get free live demo
Login
Cart
Home
Home
What is VisualCron?
Why choose VisualCron?
Our customers
Testimonials
Search
Social
Technology
Features
GENERAL
Features
Screenshots
API / SDK
Technology
ARCHITECTURE
Tasks
Triggers
Connections
AUTOMATION
General automation
Task Scheduler
FTP / SFTP/ SCP automation
Batch and exe automation
PowerShell automation
Cloud automation
Business Process Automation (BPA)
Encryption automation
SQL / database automation
Web macro recorder automation
Robotic Process Automation (RPA)
Managed File Transfer (MFT)
Extract Transform Load (ETL)
PDF automation and data extraction
XML automation and manipulation
Image automation and manipulation
Office 365, Excel and Macro Automation
Sharepoint automation
Archive automation
Virtual Machine Automation
Document scanning / OCR
ABOUT VISUALCRON
VisualCron is an
Automation
,
Integration
and
Task Scheduling Tool
for
Windows
.
Get free live demo
Download
Download
Change log
Requirements
Get free live demo
Order
Order
License guide
Choosing the right license
Basic vs Pro edition comparison
Cart
Get price quote
Use PO / get invoice
Return policy
Company information
Reseller information
Partners
Get free live demo
Support
Community forum
Documentation
Video tutorials
Maintenance & priority support
Contact us
Get free live demo
My pages
Start
My profile
My contacts
My licenses
My cloud Servers
My orders
Blog
Site map
Community forum
Support
Community forum
Please note that VisualCron support is not actively monitoring this community forum. Please use our
contact page
for contacting the VisualCron support directly.
Welcome Guest! To enable all features please
Login
or
Register
.
×
Forum
Search
Login
Register
Login
×
User Name or E-Mail Address:
Password:
Caps Lock is on
Remember me
×
Forum
Support
General problem solving
Create Excel - Workbook
Create Excel - Workbook -
can I create a multi sheet workbook
Previous Topic
Next Topic
Tools
Email this topic
Watch this topic
Print this topic
Matt Peden
Paid support
Topic Starter
2017-01-11T23:50:10Z
#1
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?
Quick Reply
Reply
View All Posts by User
Sponsor
Forum information
Wanna join the discussion?!
Login to your Forum forum account
or Register a new forum account
×
Support
Official support
2017-01-12T07:41:01Z
#2
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!
Quick Reply
Reply
View All Posts by User
Matt Peden
Paid support
Topic Starter
2017-01-12T14:57:35Z
#3
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
Quick Reply
Reply
View All Posts by User
Jon Tofte-Hansen
Paid support
2017-01-12T15:21:47Z
#4
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.
Quick Reply
Reply
View All Posts by User
Matt Peden
Paid support
Topic Starter
2017-01-12T18:06:55Z
#5
Thanks I will give that a shot
Quick Reply
Reply
View All Posts by User
Matt Peden
Paid support
Topic Starter
2017-01-12T20:18:13Z
#6
That worked Jon.
Thanks for the clarification on that functionality.
Matt Peden
Quick Reply
Reply
View All Posts by User
Similar Topics
Create Excel workbook
(
General problem solving
) by
Support
2018-09-26T18:32:17Z
Add Worksheet to existing Excel Workbook
(
General problem solving
) by
Support
2015-12-16T15:27:20Z
Excel - Create
(
General problem solving
) by
Support
2018-09-14T18:48:54Z
Excel Create Error
(
General problem solving
) by
Support
2017-06-02T16:16:09Z
Excel Create Task
(
Feature requests
) by
Niklas Larsson
2013-08-09T12:12:16Z
Users browsing this topic
Guest
Forum
Support
General problem solving
Create Excel - Workbook
© VisualCron
Scroll to Top