MS Excel - DataTable Utilities for UiPath Studio

Hover over an image to enlarge

$0.00
Q4 Associates

This product is electronically distributed.

Description

Provides utilities to convert between UiPath Datatables to/from Excel ranges, tables etc. 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 

ConvertExcelTableToUiPathDatatable

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

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

SkipHiddenRows (bool) –  Optional. Get Value or Displayed Value. True means Displayed Value. Default to be false

AnchorHeaderCellRef (string) –  Optional. If the table is very large (more than 30000 rows), this field is required. It refers to the header of a column that has no blank cells in the table

ConvertExcelRangeToUiPathDatatable

Range (string) – Optional. Default to be the used Range

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

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

Schema (DataTable) –  Optional. The output collection will follow the columns of this collection

FirstRowIsHeader (bool) – Optional. Default to be False

DisplayedValue (bool) – Optional. Get Value or Displayed Value. True means Displayed Value. Default to be false

SkipHiddenCell (bool) –  Optional. Default to be false

AvoidDateCurrencyProblem (bool) – Optional. If you have date format or currency format problem, set this to be true. Default to be false

IncludeRowRangeRef (bool) – Optional. Default to be False. True will add a column called "RangeRef" as the first column to display the corresponding range of the row in the Excel

ConvertUiPathDatatableToExcelRange

CellRef (string) – Optional. Default to be Appended

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

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

Col (DataTable) – Required

IncludeHeader (bool) – Optional. Default to be false

ConvertGroupToUiPathDatatable

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

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

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

ConvertExcelTableToUiPathDatatable

outputCollection (DataTable) – Output Collection after conversion

ConvertExcelRangeToUiPathDatatable

outputCollection (DataTable) – Output Collection after conversion

ConvertUiPathDatatableToExcelRange

Nil

ConvertGroupToUiPathDatatable

GroupRef (DataTable) – Reference of the Group

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

MSExcelCollectionUtilities

List of Functionality

ConvertExcelTableToUiPathDatatable

Convert Excel Table to Blue Prism Collection. It will skip hidden rows. You can choose displayed value, or the real value.

ConvertExcelRangeToUiPathDatatable

Convert Excel Range to Blue Prism Collection. You can choose get the displayed value or the Actrual value; Skip hidden rows and columns or not.

ConvertUiPathDatatableToExcelRange

Convert Blue Prism Collection to Excel Range .  Much more quicker than Standard VBO

ConvertGroupToUiPathDatatable

"Level" Starts from 1.

If 'GroupLastRowNumber' is omitted, 'Level' has a value, it will return the range reference for all the rows with that level;  If 'GroupLastRowNumber' has a value, 'Level' is omitted, it will return the range reference of the group just above the 'GroupLastRowNumber'. If both 'GroupLastRowNumber' and  'Level' have value, it will return the range reference for all the cells within the group just above the 'GroupLastRowNumber' whose's level equals to "Level"

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