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 |
|
Created By
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by ethanium