Common automation tasks and examples

This document lists common automation tasks and examples for the tasks.

Spreadsheet operations

Task Subtasks/approaches Example
Read data from spreadsheets If the spreadsheet is large, you can connect to it as a database. Connect to an Excel spreadsheet as database
Read individual rows. Example of transferring data from CSV file to Excel worksheet
Read data from an Excel spreadsheet and store it in a data table variable. Example of reading data from a spreadsheet
Read data from spreadsheets and write to a database. Example of migrating data from Excel to a database
Write to spreadsheets Create a new spreadsheet and write data to it. Example of reading data from a spreadsheet
Merge spreadsheets Merge two spreadsheets Run TaskBot to merge Excel sheets

SAP operations

Task Subtasks/approaches Examples
Call SAP BAPI functions Get structure. Example of using Get structure command from SAP BAPI package Example of using Run standard workflow from SAP BAPI package
Write data to SAP using SAP BAPI. Example of writing data to SAP using SAP BAPI package

Variables, control flow, and logic operations

Task Subtasks/approaches Examples
Variables Pass values between bots. Example of passing a value between bots
Use file variables. Example of using a file variable
Use dictionary variables. Create dictionary type variables
Conditions Use String condition. Example of using a conditional statement

Custom scripts integration in bots

Tasks Subtasks/approaches Example
Use custom Python scripts. Invoke Python function in bots. Build a hello world bot with a Python function
Example of using Python script to join a list
Use custom VBScript. Invoke a VBScript function. Example of using the VBScript package in a resilient bot