MS Excel - Picture Operations for UiPath Studio

Description

Work with pictures in MS Excel workbooks. Please note these activities are not mandatory to be used within Excel application scope. The Excel sheet gets attached to the UiPath with the workbook name provided as input.

Prerequisites

NA

Execution

Kindly import the NuGet package to use the activities

Inputs 

InsertPicture

ImagePath (string) – Required. Full Path of Image

X (int) – Optional. Default to be 0. The position (in pixels) of the upper-left corner of the picture relative to the upper-left corner of the document.

Width (int) – Optional. The width of the picture, in pixels.

Height (int) – Optional. The height of the picture, in pixels.

The value must be less or equal than 546.

Y (int) – Optional. Default to be 0. The position (in pixels) of the upper-left corner of the picture relative to the top of the document.

WorksheetName (string) – Optional. Default to be the active Worksheet

WorkbookName (string) – Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

FitImageInACell

ImagePath (string) – Required. Full Path of Image

CellRef (string) – Required. Address of a cell

Width (int) – Optional. Default to be Unchanged

Height (int) – Optional. Default to be Unchanged. The value must be less or equal than 546.

WorksheetName (string) – Optional. Default to be the active Worksheet

WorkbookName (string) – Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.

OpenWorkbookByPassword

WorkbookFullPath (string) - Required.Full Path of Workbook

Password (string) - Optional. If no password, just leave it empty.

MaxTimeForWaiting (int) - Optional. Default to be 120s.

CloseAllInstances

Nil

Outputs

InsertPicture

Success (bool) – True if succeeded

ErrorMes (string) – Error message if any

FitImageInACell

Success (bool) – True if succeeded

ErrorMes (string) – Error message if any

OpenWorkbookByPassword

WorkbookFullPath (string) - Required.Full Path of Workbook

Password (string) - Optional. If no password, just leave it empty.

MaxTimeForWaiting (int) - Optional. Default to be 120s.

CloseAllInstances

Nil

Components Included

Process

Main

NuGet Package

MSExcelPictureOperations

List of Functionality

InsertPicture

Insert a picture to a region in worksheet. To an excel cell, the maximum height is 409.5 Points, equals to 546 pixels (1 Point = 4/3 Pixel). Sometimes we set the rate of Width to Height to be 4:3, so if the row height is 546, the column width should be 546*4/3=728. So width = 728, height = 546 is one of the recommended combo. Example: ("C:\User\Pictures\Demo.png",50, 50, 728, 546,,)...........Example: ("C:\User\Pictures\Demo.png",,,,,,)

FitImageInACell

Set the ColumnWidth or RowHeight of a cell, and insert an image into this cell. The image will be full fit this cell. To an excel cell, the maximum height is 409.5 Points, equals to 546 pixels (1 Point = 4/3 Pixel). The unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used. The transfer formula between character and point is: 1 character = ( 1 Pixel - 5)/7. Sometimes we set the rate of Width to Height to be 4:3, so if the row height to be 546, the width should be 546*4/3=728. So width = 728, height = 546 is one of the recommended combo.  Example: ("C:\User\Pictures\Imgae1.png", "A1", 728, 546,,)..........Example: ("C:\User\Pictures\Imgae1.png", "F5", , ,,) -> RowHeight and ColumnWidth keep unchanged.

OpenWorkbookByPassword

The handler is from the default instance which is the first instance. This function could open the Excel file directly from Remove Server by using the http or https path or UNC path, while the standard Excel VBO could only use UNC path.

CloseAllInstances

Closes all instances of excel which have been opened by this business object, either through "Create Instance" or "Open Instance" and which have not been discarded through "Close Instance" or "Release Instance"