Copy and Paste Selection

Activity Description

Copies the contents of a specified area of an Excel worksheet and pastes it into another Excel worksheet or other area of the current Excel worksheet.

Property Description

Target range name

The format refers to the attribute “Source Area”, after filling in the value, you can paste the copied content under the selection.

Target worksheet name

Fill in the name, the copied content will be copied to the specified Excel workbook name of the corresponding worksheet

Target File Path

Paste the copied content into the file path contained in the file, you can fill in manually, or by clicking the icon on the right side of the input box to select the full path to the file.

Worksheet name

Fill in the name of the Excel sheet to copy the contents of the corresponding cell in the sheet.

Whether to include formulas

Choose whether to include formulas or not from the drop-down box to support copying values and including formulas.

Full path of the file

Copy the content of the corresponding Excel worksheet by filling in the full path of the Excel file, or by clicking the icon on the right side of the input box to select the full path of the file

Source selection

The default value is “A1:A2”, which can be modified according to the actual situation.

Usage Example

Execution steps: Excel table, Sheet1 worksheet in the region of A1: B6 paste to sheet4 in the region of A1: B6 - to obtain the region of A1: B6 content - to view the results of the operation

Note: the implementation of the activity, the first activity to be used to close the Excel file