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