Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

Blue Prism VBO Cheat Sheet by

Blue Prism MAPIEx

Configure
Delete Mail
Get Contacts
Get Mail
List Mails Within DateTimes
Move Mail
Reply To Mail
Send Mail

Calendars

Add Working Days
Count Working Days In Range
Get Other Holidays In Range
Get Public Holidays In Range
Get Working Days In Range
Is Other Holiday
Is Public Holiday
Is Weekend
Is Working Day

Data - OLEDB

Close
Get Collection
Open
Set Connection

Data - SQL Server

Begin Transa­ction
Commit Transa­ction
Configure
Execute
Get Collection
Get CSV
Get CSV File
Get Number
Get Records Affected
Get Text
Rollback Transa­ction
Set Connection

Email - POP3/SMTP

Configure
Delete Message
Delete Messages
Get Message
List Messages
Save Attach­ments
Send Message

Login Agent

Change Password
Get Credential Name
Is Locked
Is Logged In
Lock Screen
Log In
Log Out
Logged In Users
Unlock Screen

MS Excel VBO

Activate Workbook
Activate Worksheet
Attach
Attach to workbook
Close All Instances
Close Current Workbook
Close Instance
Close Workbook
Copy
Copy and Paste Worksheet Range
Create Instance
Create Workbook
Create Worksheet
Cut
Delete
Delete Worksheet
Exit
Find Next Empty Cell
Format Cell
Format Current Cell
Get Active Cell
Get Active Cell Value
Get Cell Value
Get Formatted Cell Value
Get Number Of Rows
Get Worksheet As Collection
Get Worksheet As Collection (Fast)
Get Worksheet as Collection Offset
Get Worksheet Name
Get Worksheet Names
Get Worksheet Position
Get Worksheet Range As Collection
Go To Cell
Go To Next Cell
Go To Next Empty Cell Down
Go To Next Empty Cell Left
Go To Next Empty Cell Right
Go To Next Empty Cell Up
Hide
Hide Other Worksheets
Hide Worksheet
Import CSV
Insert
Is Read Only
Move Worksheet
Open Instance
Open Workbook
Paste
Protect Workbook
Release Instance
Remove Blank Rows
Run Macro
Save Current Workbook
Save Current Workbook As
Save Workbook
Save Workbook As
Select
Set Cell Value
Set Current Instance
Set Events Enabled
Set Window Location
Set Window Size
Set Window State
Show
Split Worksheet
Worksheet Exists
Write Collection
Write To Clipboard
 

MS Word VBO

Add Table Row
Attach Instance
Clear Clipboard
Close
Copy to Clipboard
Create Document
Create Instance
Detach Instance
Exit
ExportPDF
Find Text
Get Body
Get Footer Text
Get Highli­ghted Text
Get Table Cell Value
Hide
Open
Paste from Clipboard
Replace Highli­ghted Text
Save As
Select All
Select Next Cell
Select Next Field
Set Current Instance
Set Selected Cell Text
Set Selected Checkbox
Set Table Cell Value
Show
Type Text
Update Bookmark

System - Active Directory

Add User to Group
Create User
Object Exists (Dynamic)
User Exists (Displ­ayname)
User Exists (UserP­rin­cip­alName)

Utility - Collection Manipu­lation

Append Field (Number)
Append Field (Text)
Append Rows to Collection
Collection Contains Field
Collection Contains Value
Copy Rows
Delete Column
Delete Field
Field Exists
Fill Blanks
Filter Collection
Get Collection Fields
Merge Collection
Read Collection Field
Remove dots from headers
Remove Empty Rows
Remove Null Rows
Rename Collection Fields
Rename Field
Reverse Collection
Set Collection Field
Set Column Names From Expected Collection
Set Column Names From First Row
Sort Collection
Split Collection
Transpose Collection

Utility - Date and Time Manipu­lation

DateAdd
Format Date
Get Last Working Day
Get Maximum TimeSpan
Get Time of Day
Get Time Zones
local to UTC
UTC to local

Utility - Encryption

Decrypt
Encrypt

Utility - Enviro­nment

Clear Clipboard
Font Smoothing Enabled
Get Clipboard
Get Machine Name
Get Screen Resolution
Get User Name
Kill Process
Read Memory Stats
Read Process Working Set
Run Process Until Ended
Set Clipboard
Start Process
Wait for Process
Wait for Process Window

Utility - File Management

Append to Text File
Append to Text File
Combine Path
Configure
Copy File
Create Directory
Delete Directory
Delete File
Delete Files
Directory Exists
Download File
File Exists
Get CSV Text As Collection
Get File Size
Get Files
Get Folders
Get Special Folder Path
Move File
Read All Text from File
Read Lines From File
Split Path
Sub Directory Exists
Write Binary Data
Write Text File
 

Utility - Foreground Locker

Lock Foreground
Release Foreground Lock

Utility - General

Process Exists
Sleep
Window Exists

Utility - HTTP

HTTP Request
Load Certif­icate
Post
Post JSON

Utility - Image Manipu­lation

Find First Pixel From Bottom
Find First Pixel From Left
Get Sub Image Position
Image Contains Colour
Image Is Uniform Colour
Image is White

Utility - Image Search

Find Image
Find Image (all instances)
Find Image (all instances, by one colour)
Find Image (by one colour)

Utility - JSON

Collection to JSON
JSON to Collection

Utility - Locking

Lock Item
Release Lock
Set Up Queue Item

Utility - Network

Ping

Utility - Numeric Operations

Calculate Rolling Average (fixed denomi­nator)
Calculate Rolling Average (variable denomi­nator)
Get Absolute Value

Utility - Strings

Compare Font Text
Delete Characters
Escape Sendkeys String
Extract Regex Values
Format Number
Generate New GUID
Get Collection as CSV
Get CSV As Collection
Get Newline Character
Get XML Attribute
Get XML Elements
InStr
InStrRev
Join Lines
Join Text
PadLeft
Remove Non-word Characters
Split Lines
Split Lines by Length
Split Text
Test Regex Match

Utility - WebServer

Create Certif­icates
Launch

Utility - XML

Get Attribute
Get Child Elements
Get Element
Get Elements
Get Elements By XPath
Read File
Strip Tags

Webser­vices - OAuth2.0

Load Certif­icate
Request

Webser­vices - REST

Delete
Get
Post
Put
Setup OAuth

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

Metadata

  • Languages:
  • Published: 20th June, 2017
  • Rated: 5 stars based on 6 ratings

Favourited By

rmate

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          More Cheat Sheets by ethanium