How to create multiple sheets in a single excel file in a GoAnywhere project?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Mary

Support Specialist
Posts: 11
Joined: Tue Feb 09, 2010 11:16 am

Post by Support_Mary » Wed Oct 10, 2018 10:37 am
Question:
How to create multiple sheets in a single excel file?

Answer:
Use the Write Excel task twice. Once for the first sheet and then on the second Write Excel Task use select Rename Sheet for the parameter, When Output File Exists. This creates a new sheet within the existing file. All other sheets within that file will remain untouched. The new sheet will have the specified sheet name, plus a numeric suffix.
1 post Page 1 of 1