本文转自:https://www.cheatography.com/ethanium/cheat-sheets/blue-prism-vbo/
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 Transaction
|
Commit Transaction
|
Configure
|
Execute
|
Get Collection
|
Get CSV
|
Get CSV File
|
Get Number
|
Get Records Affected
|
Get Text
|
Rollback Transaction
|
Set Connection
|
Email - POP3/SMTP
Configure
|
Delete Message
|
Delete Messages
|
Get Message
|
List Messages
|
Save Attachments
|
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 Highlighted Text
|
Get Table Cell Value
|
Hide
|
Open
|
Paste from Clipboard
|
Replace Highlighted 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 (Displayname)
|
User Exists (UserPrincipalName)
|
Utility - Collection Manipulation
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 Manipulation
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 - Environment
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 Certificate
|
Post
|
Post JSON
|
Utility - Image Manipulation
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 denominator)
|
Calculate Rolling Average (variable denominator)
|
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 Certificates
|
Launch
|
Utility - XML
Get Attribute
|
Get Child Elements
|
Get Element
|
Get Elements
|
Get Elements By XPath
|
Read File
|
Strip Tags
|
Webservices - OAuth2.0
Load Certificate
|
Request
|
Webservices - REST
Delete
|
Get
|
Post
|
Put
|
Setup OAuth
|
Blue Prism Internal Business Objects Cheat Sheet
https://www.cheatography.com/ethanium/cheat-sheets/blue-prism-internal-business-objects/
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
|
Collections
Add Row
|
Copy Rows
|
Count Columns
|
Count Rows
|
Remove All Rows
|
Remove Row
|
Credentials
Generate and Set
|
Generate Password
|
Get
|
Get Property
|
List
|
Mark as Invalid
|
Set
|
Set Property
|
Encryption
Decrypt Binary
|
Decrypt Collection
|
Decrypt Date
|
Decrypt DateTime
|
Decrypt Flag
|
Decrypt Number
|
Decrypt Password
|
Decrypt Text
|
Decrypt Time
|
Decrypt TimeSpan
|
Encrypt Binary
|
Encrypt Collection
|
Encrypt Date
|
Encrypt DateTime
|
Encrypt Flag
|
Encrypt Number
|
Encrypt Password
|
Encrypt Text
|
Encrypt Time
|
Encrypt TimeSpan
|
Work Queues
Add To Queue
|
Copy Item to Queue
|
Defer
|
Delete Item
|
Delete Processed Items
|
Get Completed Items
|
Get Exception Items
|
Get Item Data
|
Get Locked Items
|
Get Next Item
|
Get Pending Items
|
Get Queue Names
|
Get Report Data
|
Get Transaction Data
|
Is Item In Queue
|
Mark Completed
|
Mark Exception
|
Set Data
|
Set Priority
|
Tag Item
|
Unlock Item
|
Untag Item
|
Update Status
|