Skip to content

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.
Post Reply
  • Support_Mary
  • Support Specialist
  • Posts: 11
  • Joined: Tue Feb 09, 2010 11:16 am

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

by Support_Mary »

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.
Post Reply

Return to “Knowledge Center”