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" |
Disclaimer: References in this site to UiPath products, activities or services or the use of any UiPath trade name are made solely to indicate compatibility of products available on RPA Marketplace with UiPath products, and do not constitute or imply the development, endorsement, recommendation or approval by UiPath of the same.
No posts found