Man illustrationFlower illustration

Docy

Copy

Estimated reading: 2 minutes 70 views

Copy 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.
DestinationSets destination cell on which operation will write the result.
Source excelThe Excel which will be retrieved data.
Source sheetThe Excel sheet which will be retrieved data.
RangeExcel sheet range from which to fetch data.
*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). If there is a formula in Excel, copy results 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 Destination as shown in the example.

D1

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

${newExcel}

You can use the Range as shown in the example.

A1:B5

You can use the Shift as shown in the example.

Copies the data to the current location that is already data:

NONE

Copies your data to a valid location by shifting the current data to the right:

RIGHT

Copies your data to the 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.

If there are two separate excels and if there is a copy operation between these two excels, the Sheet name, Source sheet and Excel name fields must be filled.

CONTENTS