Man illustrationFlower illustration

Copy

Estimated reading: 2 minutes 242 views

Copy 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.
DestinationIt can be determined from which cell the copied data will be written in excel.
Source sheetThe Excel sheet name which will be retrieved data is written.
RangeThe range of cells to be copied is given.
*ShiftSpecifies how to copy the dataset to the Excel file.
Copy as valueIt is the choice of copying the data to be copied with its values (without formulas).

Note: This checkbox will be important if there is a formula in Excel. If you want to hold the values you can copy the results as a value. If you do not check this box, you can lose the values.
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 Destination as shown in the example.

D1

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

Sheet2

You can use the Range as shown in the example.

A1:B5

You can use the Shift as shown in the examples.

Copies the data to current location that has already data:

NONE

Copies your data to current place by moving the existing data to the right:

RIGHT

Copies your data to current location by moving the existing data down:

DOWN

Sheet name fields do not have to be filled if the first page of the excel files will be copied. Otherwise it must be filled.

Share this Doc

Copy

Or copy link

CONTENTS
Chat Icon Close Icon