Description |
Provides utility functions for converting MS Excel cell references. 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 |
ColumnNumbertoLetter Num (int) – Number which needs to be converted to corresponding column letters
ColumnLettertoNumber Letter (string) – column letters which needs to be converted to corresponding number
SplitRowAndColumnFromCellRef
CellRef (string) – The address of a cell, like "AC31", "$R$21"
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 |
ColumnNumbertoLetter Letter (string) – Alphabetical value after conversion
ColumnLettertoNumber
Num (int) – Number after conversion
SplitRowAndColumnFromCellRef
RowRef (string) – Row Reference after splitting
ColumnRef (string) – Column Reference after splitting
CellRef (string) – Cell Reference
OpenWorkbookByPassword
Name (string) - The name used by Excel to identify the workbook - usually this is the file name (without the path).
CloseAllInstances Nil |
Components Included |
Process Main
NuGet Package
MSExcelCellRefUtilities |
List of Functionality |
ColumnNumbertoLetter Convert a number to corresponding column letters. Examples: 1 => "A" 26 => "Z" 27 => "AA" 51 => "AY" 702 => "ZZ" 703 => "AAA" -1 => "" -234=> ""
ColumnLettertoNumber Convert a column string to a corresponding number. Examples: "A"=>1 "Z"=>26 "ZZ"=>702 "AAA"=>703 "aZZ"=>0 "A Z"=>0
SplitRowAndColumnFromCellRef Split the address of a cell into Row and Column. Examples: "AC31" => "AC","31"........... "$T$22" => "T", "22"
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