Lea y revise la documentación de Automation Anywhere

Automation 360

Cerrar contenidos

Contenidos

Abrir contenidos

Example of sharing an Excel session between bots

  • Actualizado: 2021/08/11
    • Automation 360 v.x
    • Explorar
    • Espacio de trabajo de RPA

Example of sharing an Excel session between bots

Build two bots to update the employee salaries in a worksheet. In this example, one bot opens an Excel worksheet and passes the session name as a variable to the second bot, which iterates through the worksheet, calculates each employee's new salary, and updates the value in the worksheet.

Antes de empezar

Create a worksheet with the following data:
Employee ID Fecha de inicio Salary
200 1/12/2020 50000
233 3/15/2018 75000
500 6/6/2020 60000
555 7/9/2019 65000

Procedimiento

Build the child to iterate through the table of employees and update each salary to reflect the raise.

  1. Abrir un nuevo bot.
    1. From Automation Anywhere web interface, on the left panel, click Automation.
      Se muestra la lista de bots y formularios disponibles.
    2. Haga clic en Crear un bot.
    3. Enter the bot name RaiseSalaries.
    4. Enter the folder location \Bots\TaskBotExample.
      Si desea cambiar la ruta de almacenamiento de su bot, haga clic en Elegir y siga las indicaciones.
    5. Haga clic en Crear y editar.
  2. Create the following variables:
    • sessionVariable: session type; MS Excel subtype; use as input
    • sCellAddress: string type; default valu