Copy/Remove sheet

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


*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default. Note: When the “Action” property is selected as “Remove”, the “Sheet Name” field must be filled.
*Action	The desired action is selected.
Source excel	The excel reference name from which the data will be received is chosen in the dropdown.
New sheet name	The name of new sheet to create in Excel is written.
Copy as value	If the checkbox is selected, formulas in Excel will be copied as a value.

Note: * Fields selected with are required, others are optional.

Excel name example

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

${newExcel}

Sheet name example

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

Sheet1

Action example

You can use the Action as shown in the example.

COPY

REMOVE

Source excel example

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

${copyExcel}

New sheet name example

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

NewSheet

Note

The 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.