Cheatography
https://cheatography.com
Blue Prism MAPIExConfigure | Delete Mail | Get Contacts | Get Mail | List Mails Within DateTimes | Move Mail | Reply To Mail | Send Mail |
CalendarsAdd 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 - OLEDBClose | Get Collection | Open | Set Connection |
Data - SQL ServerBegin 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/SMTPConfigure | Delete Message | Delete Messages | Get Message | List Messages | Save Attachments | Send Message |
Login AgentChange Password | Get Credential Name | Is Locked | Is Logged In | Lock Screen | Log In | Log Out | Logged In Users | Unlock Screen |
MS Excel VBOActivate 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 VBOAdd 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 DirectoryAdd User to Group | Create User | Object Exists (Dynamic) | User Exists (Displayname) | User Exists (UserPrincipalName) |
Utility - Collection ManipulationAppend 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 ManipulationDateAdd | Format Date | Get Last Working Day | Get Maximum TimeSpan | Get Time of Day | Get Time Zones | local to UTC | UTC to local |
Utility - EnvironmentClear 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 ManagementAppend 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 LockerLock Foreground | Release Foreground Lock |
Utility - GeneralProcess Exists | Sleep | Window Exists |
Utility - HTTPHTTP Request | Load Certificate | Post | Post JSON |
Utility - Image ManipulationFind 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 SearchFind Image | Find Image (all instances) | Find Image (all instances, by one colour) | Find Image (by one colour) |
Utility - JSONCollection to JSON | JSON to Collection |
Utility - LockingLock Item | Release Lock | Set Up Queue Item |
Utility - Numeric OperationsCalculate Rolling Average (fixed denominator) | Calculate Rolling Average (variable denominator) | Get Absolute Value |
Utility - StringsCompare 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 - WebServerCreate Certificates | Launch |
Utility - XMLGet Attribute | Get Child Elements | Get Element | Get Elements | Get Elements By XPath | Read File | Strip Tags |
Webservices - RESTDelete | Get | Post | Put | Setup OAuth |
|
Help Us Go Positive!
We offset our carbon usage with Ecologi. Click the link below to help us!
Created By
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by ethanium