Lea y revise la documentación de Automation Anywhere

Automation 360

Cerrar contenidos

Contenidos

Abrir contenidos

Using the Copy worksheet action

  • Actualizado: 2020/11/17
    • Automation 360 v.x
    • Crear
    • Espacio de trabajo de RPA

Using the Copy worksheet action

Use the Copy worksheet action to copy values of a worksheet from one worksheet to another. This action overwrites any existing values. To move values from one worksheet to another without overwriting existing values, use the Append worksheet action.

Antes de empezar

Open the workbook(s) containing the source and target worksheets. Consulte Utilizar la acción Abrir.
Nota: This action identifies the destination and source workbooks by the session names used to open them. If opening two workbooks, enter a session name for the source workbook that is different than the one used to open the destination workbook.
To copy the values of a worksheet into another, do the following:

Procedimiento

  1. Double-click or drag the Copy worksheet action.
  2. Enter the name of the session that you used to open the destination workbook in the Open action.
  3. If the workbook contains more than one worksheet, mark the Specific Sheet option, then enter the index number or name of the source worksheet.
    • The index number represents the position of the worksheet in the workbook. For example, to perform an operation on the worksheet at the third position in the workbook, enter 3 in the field.
    • The sheet name field is case insensitive.
  4. Enter the name of the session that you used to open the source workbook in the Open action.
  5. If the workbook contains more than one worksheet, mark the Specific Sheet option, then enter the index number or name of the destination worksheet.
  6. Haga clic en Guardar.
Enviar comentarios