MS Excel - Cell Reference Utilities for UiPath Studio

Hover over an image to enlarge

$0.00
Q4 Associates

This product is electronically distributed.

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

Write a review
Immediately Available

Most products are downloadable and available immediately after purchase

Quality assurance and service

We vet all products for quality and best practise

Refunds within 20 days

You have 20 days to test your purchase and request a refund if it doesn't meet your expectations