[转]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 |
SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
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 |
更多精彩
