How to create multiple sheets in a single excel file in a GoAnywhere project?
Posted: 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.
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.