Copy
Copy 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. |
| Destination | It can be determined from which cell the copied data will be written in excel. |
| Source excel | The excel reference name from which the data will be received is chosen in the dropdown. |
| Source sheet | The Excel sheet name which will be retrieved data is written. |
| Range | The range of cells to be copied is given. |
| *Shift | Specifies how to copy the dataset to the Excel file. |
| Copy as value | It 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.
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
Destination example
You can use the Destination as shown in the example.
D1
Source excel example
You can use the Source excel as shown in the example.
${newExcel}
Range example
You can use the Range as shown in the example.
A1:B5
Shift examples
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
Note
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.