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. |
| New sheet name | The name of new sheet to create in Excel is written. |
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
New sheet name example
You can use the New sheet as shown in the example.
NewSheet