正文
[转]Blue Prism VBO Cheat Sheet
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
本文转自：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
|
