How to create multiple sheets in a single excel file in a GoAnywhere project?
Posted: Wed Oct 10, 2018 10:37 am
Overview
This article will discuss how to create multiple sheets in a single excel file for Projects.
Environment
GoAnywhere MFT - all versions
Projects with Write Excel Tasks
Resolution
Use the Write Excel task twice. Once for the first sheet and then on the second Write Excel Task, 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.
This article will discuss how to create multiple sheets in a single excel file for Projects.
Environment
GoAnywhere MFT - all versions
Projects with Write Excel Tasks
Resolution
Use the Write Excel task twice. Once for the first sheet and then on the second Write Excel Task, 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.