examples

EasyRPA Open Framework Examples

Email
Excel
Google Services
Google Drive
Google Sheets
Database

Email

• Sending of simple email message

• Sending of message with attachments

• Creating of message based on FreeMarker template

• Reading messages from inbox

• Searching of messages based on specified condition

• Waiting of message based on specified condition

• Reading of attached files

• Mailbox messages manipulating

  • Forward message
  • Reply on message
  • Mark messages as Read/Unread
  • Delete message

• Getting a list of existing mailbox folders

• Mailbox folders manipulating

  • Create new folder
  • Rename folder
  • Delete folder

Excel

• Creating of new Excel file

• Reading data from given sheet

  • Read values of specific cells
  • Read values of cell range
  • Read the list of sheet table records

• Editing of existing Excel file

  • Edit specific cells
  • Edit specific cell range
  • Edit sheet table records

• Working with large Excel files

  • Read sheet table records
  • Edit sheet table records

• Copying of sheet from one Excel file to another

• Sheets manipulating

  • List existing sheets
  • Activate sheet
  • Rename sheet
  • Move sheet
  • Clone sheet
  • Delete sheet

• Working with sheet rows

  • Lookup and edit rows
  • Insert new rows
  • Delete rows

• Working with sheet columns

  • Read column cells
  • Add/insert new columns
  • Move columns
  • Delete columns
  • Sort table columns
  • Filter table columns

• Working with formulas

  • Edit cell's formulas
  • Evaluating of cell's formulas
  • Evaluating of cell's formulas with links to external Excel files

• Working with merged cells

  • Read value from merged cells
  • Merge/unmerge cells

• Working with pivot tables

  • Create pivot table
  • Read pivot table
  • Update pivot table

• Changing cells style (fonts, colors etc.)

• Inserting image to sheet

• Exporting Excel file to PDF

• Running of macros

• Running of custom VB script

Google Services

• Google API service authorization and instantiation

• Passing of Google authorization without side help

Google Drive

• Getting of files from Google Drive

• Files manipulating

  • Upload new file
  • Rename file
  • Move file
  • Delete file

• Folders manipulating

  • Create folder
  • Rename folder
  • Delete folder

Google Sheets

• Creating of new Spreadsheet

• Reading data from Spreadsheet

  • Read values of specific cells
  • Read values of cell range
  • Read the list of sheet table records

• Editing of existing Spreadsheet

  • Edit specific cells
  • Edit specific cell range
  • Edit sheet table records

• Copying of sheet from one Spreadsheet to another

• Sheets manipulating

  • List existing sheets
  • Activate sheet
  • Rename sheet
  • Move sheet
  • Clone sheet
  • Delete sheet

• Working with sheet rows

  • Lookup and edit rows
  • Insert new rows
  • Delete rows

• Working with sheet columns

  • Read column cells
  • Add/insert new columns
  • Move columns
  • Delete columns

• Working with formulas

  • Edit cell's formulas
  • Evaluating of cell's formulas

• Working with merged cells

  • Read value from merged cells
  • Merge/unmerge cells

• Changing cells style (fonts, colors etc.)

• Export Spreadsheet as XLSX file

Database

• Database tables manipulating

  • Create table to store specific entities
  • Drop entity table

• Working with database table records

  • Read table records
  • Add new table records
  • Update table records
  • Delete table records

• Working with raw SQL queries

  • Execute SELECT query
  • Execute UPDATE statement
  • Execute INSERT statement
  • Execute DELETE statement

• Working with transaction

• Working with different database types