Man illustrationFlower illustration

Docy

Copy/Remove sheet

Estimated reading: 2 minutes 66 views

Copy/Remove sheet activity is used for copying data in a specified range from an Excel file.


*Excel nameThe name of the Excel file that was opened or created before is selected.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
*ActionThe desired action is selected.
Source excelThe excel which will be retrieved data.
New sheet nameThe name of new sheet to create in Excel.
Copy as valueFormulas in Excel will be copied as a value.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Action as shown in the example.

COPY

REMOVE

You can use the Source excel as shown in the example.

${copyExcel}

You can use the New sheet as shown in the example.

NewSheet

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If Copy operation will be done in the same excel file, new sheet name and sheet name fields should be filled. Source excel, new sheet name and sheet name fields must be filled in if copy operation will be done in different excel files.

CONTENTS