Man illustrationFlower illustration

Copy/Remove sheet

Estimated reading: 2 minutes 194 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet nameThe 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.
Sheet indexIndex 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 reference name from which the data will be received is chosen in the dropdown.
New sheet nameThe name of new sheet to create in Excel is written.
Copy as valueIf the checkbox is selected, formulas 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 Sheet index as shown in the example.

5

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

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.

Share this Doc

Copy/Remove sheet

Or copy link

CONTENTS
Chat Icon Close Icon