Read and Review Automation Anywhere Documentation

Integrations

Close Contents

Contents

Open Contents

Create a custom output processor for RPA Bots for Excel

  • Updated: 5/12/2020
    • Automation 360 v.x
    • Manage
    • AARI
    • Process flow

Create a custom output processor for RPA Bots for Excel

You can use the default processor or create a custom output processor to process the data that is returned from the bot. The output processor is a JavaScript code.

You can create a custom output processor in Javascript code from the Customize Output tab, and the code will run in JavaScript API for Office. To perform any Excel function, you must call JavaScript API for Office. See https://docs.microsoft.com/en-us/office/dev/add-ins/reference/javascript-api-for-office.

Optionally, you can select the Advanced Scripting tab and use the default option Default: Save to Cell if you do not want to create a custom output processor. The option saves the results in the AutomationBotResult Excel sheet.

Procedure

  1. From the Excel application, select Automation > Processors.
  2. Select the Customize Output or Advanced Scripting tab based on your business requirements.
    • Create a Custom output processor (Novice user)
      1. Click Customize Output.
      2. In the Customize Output page in the right panel, click the Output drop-down list and select Default: Save to Cell.
      3. Enter the sheet name in the Save to Sheet field. Optionally, edit the default option, AutomationBotResult, and append the sheet with a name. For example, AutomationBotResultPP.
      4. Select the With append Run ID check box to trigger the bot results with a unique ID number in the sheet name. For example, AutomationBotResult-{ID}. The ID number is unique to every triggered bot.
      5. In the Output Starting Cell field, enter the cell range where you want the output to begin displaying from.
      6. Click Vertical or Horizontal to indicate the direction of the data you want to display in the sheet.
      7. Enter the code in the Test Result Data field.
      8. Click Save to save the processor.
      9. Enter a sheet name in the Save Processor As field to create a new custom processor.
      10. Click Save.

        The following message appears: Output Customization Saved.

        The new output processor is saved and available from the Output Processing Options field. Select the new output processor from the Output tab to execute a bot using the processor. Save the output processor as a favorite bot (Bot#1, Bot#2, or Bot#3) from the Output tab for a one-click bot run.

      11. Click Test to test the output processor.
      12. Click Delete to delete the output processor.
    • Accept Default and choose Advanced Scripting (Novice user)
      1. Click Advance Processor.
      2. In the Advanced Scripting page in the right panel, select from the Default: Save to Cell option. The default option appears in the Script Name field. The results from the last successful bot run appears in the Test Data field.
      3. Optional: Edit the code in the Code field.

        You can customize two variables in the Code field: the default spreadsheet name and the cell location variables. The default spreadsheet variable is AutomationBotResult and the default cell location variable is A1. Edit the AutomationBotResult and cell location variables as required. The processor exports the results to the AutomationBotResult Excel sheet. You can save the data to any file.

      4. Click Save to save the processor.
      5. Enter a sheet name in the Save Processor As field to create a new custom processor.
      6. Click Save.

        The following message appears: Output Customization Saved.

        The new output processor is saved and available from the Output Processing Options field. Select the new output processor from the Output tab to execute a bot using the processor. Save the output processor as a favorite bot (Bot#1, Bot#2, or Bot#3) from the Output tab for a one-click bot run.

      7. Optional: Edit the code in the Test Data field.
      8. Click Test to test the data.
      9. Click Delete to delete the data.
    • Create new script and choose Advanced Scripting (Advanced user)
      1. Enter the name of the script code in the Script Name field.
      2. Enter the code in the Code field.
      3. Optional: Edit the results from the successful bot run in the Test Data field.
      4. Click Save to the save the script.
      5. Enter a sheet name in the Save Processor As field to create a new custom processor.
      6. Click Save.

        The following message appears: Output Customization Saved.

        The new output processor is saved and available from the Output Processing Options field. Select the new output processor from the Output tab to execute a bot using the processor. Save the output processor as a favorite bot (Bot#1, Bot#2, or Bot#3) from the Output tab for a one-click bot run.

      7. Click Test to the script.
      8. Click Delete to delete the script.
Send Feedback