🔰blue prismの標準VBOとDXで入手できる主なVBO

blue prismは外向けに情報がほとんど出ていないので、何ができるか迷うよね😣😥👎 でも大丈夫、そんな貴方のために、blue prismで使える26の標準VBO (Visual Business Object)とアクションの一覧を紹介するよ😚😄 活用してね😘✨

対象

* Blue Prism 6.5.0.12573

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/500776/c1e9328a-6092-d12b-1147-3e4e4222c094.png)


# 標準Visual Business Object
`C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO\` にXMLの形でスキーマが置かれているようだね😚😄

### Calendars
Functions for working with calendars and dates.

* 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
A SQL interface for interacting with OLEDB data sources.

* Close
* Get Collection
* Open
* Set Connection
* Execute

### Data - SQL Server
SQL Server interaction object.

* Begin Transa­ction
* Commit Transa­ction
* Configure
* Execute
* Get Collection
* Get CSV File
* Get Number
* Get Records Affected
* Get Text
* Rollback Transa­ction
* Set Connection

### Email - POP3/SMTP
Retrieve email via POP3 protocol and send using SMTP protocol.

* Configure
* Delete Message
* Get Message
* List Messages
* Save Attach­ments
* Send Message

### Google Sheets
Common actions to interact with Google Sheets. Requires a Google API Client ID and Secret for operation - these must be created as Environment Variables called "Google Sheets API Client ID" and "Google Sheets API Client Secret" respectively

* Get Range Values
* Set Range Values
* Append Data
* Clear Range
* Create Workbook
* Get API Tookens

### MS Excel
VBO for interacting with Microsoft Excel.

* 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 Outlook Email
VBO for interacting with Microsoft Outlook email functions.

* Send Email
* Reply All to Email
* Reply to Email
* Forward Email
* Save Email As File
* Delete Email
* Mark Email As Read
* Mark Email As Unread
* Move Email to Inbox Sub Folder
* Save Attachments
* Save Attachment
* Get Sent Items (Basic)
* Get Sent Items (Advanced)
* Get Sent Items (Expert)
* Get Received Items (Basic)
* Get Received Items (Advanced)
* Get Received Items (Expert)

### MS Word
VBO for interacting with Microsoft Word.

* 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 Highli­ghted Text
* Get Table Cell Value
* Hide
* Open
* Paste from Clipboard
* Replace Highli­ghted 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
Business Object for interacting with Active Directory using the LDAP based API in .NET.

* Add User to Group
* Create User
* Object Exists (Dynamic)
* User Exists (Displ­ayname)
* User Exists (UserP­rin­cip­alName)

### Utility - Collection Manipu­lation
Utility functions for manipulating collections.

* 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 Manipu­lation
Utility functions for manipulating dates and times.

* 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
Provides encryption and decryption facilities. Use the BPServer interface to generate a key to use with these actions.

* Decrypt
* Encrypt

### Utility - Enviro­nment
Utilities for interacting with the environment - read screen resolution, determine OS type, etc.

* 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
Utility methods for interacting with the file System.

* 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
Controls access to foreground operations by providing a locking mechanism.

* Lock Foreground
* Release Foreground Lock

### Utility - General
General utility functions which don't fit into specific categories.

* Process Exists
* Sleep
* Window Exists

### Utility - HTTP
Communicates with web services using the HTTP protocol.

* HTTP Request
* Load Certif­icate
* Post
* Post JSON

### Utility - Image Manipu­lation
Utility methods for analysing and manipulating images.

* 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 - JSON
An object for parsing JSON into a collection and turning a collection into JSON.

* Collection to JSON
* JSON to Collection
* JSON to Collection (skipping JArray)

### Utility - Locking
Manages locks on items.

* Lock Item
* Release Lock
* Set Up Queue Item

### Utility - Network
A utility object with network related actions.

* Ping

### Utility - Numeric Operations
Mathematical functions

* Calculate Rolling Average (fixed denomi­nator)
* Calculate Rolling Average (variable denomi­nator)
* Get Absolute Value

### Utility - Strings
Utility functions for manipulating text.

* 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 - Windows Compressed File
The VBO utility to manage Windows Compressed files

* Create Zip from Folder
* Add File to Zip
* Extract All from Zip
* Delete File from Zip
* Get Zip Contents
* Find File in Zip

### Webser­vices - OAuth2.0
Business Object for authorization using OAuth2.0.

* Load Certif­icate
* Request

### Webser­vices - REST
Connects to REST based webservice API's.

* Delete
* Get
* Post
* Put
* Setup OAuth

# Blue Prism Digital Exchange (クラウド)
Blue Prism DX ( https://digitalexchange.blueprism.com/dx/ )で使える主なVBOは以下のページにまとまっているので見てね😘✨

* [Blue Prism オンボーディング ～はじめよう! Blue Prism～ 第 6 回 Blue Prism Digital Exchange (DX) から部品をダウンロード](https://www.blueprism.com/japan/resources/blog/blue-prism-onboarding-06/) - ブログ