MS Excel - Extended File Operations for UiPath Studio

Description

Provides extended file operations for working with 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 

ActivateExcelAppWindow

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

MaximizeExcelAPPWindow

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

MinimizeExcelAPPWindow

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

ActivateExcelAppWindow

Caption (string) - Workbookname

MaximizeExcelAPPWindow

Caption (string) - Workbookname

MinimizeExcelAPPWindow

Caption (string) - Workbookname

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

MSExcelExtendedFileOperations

List of Functionality

ActivateExcelAppWindow

Activate the Excel Window. It's different from the "Activate Workbook" in Standard Excel VBO.

MaximizeExcelAPPWindow

Maximize the Excel Window and Activate the workbook. Return the name of the Excel App Window.

MinimizeExcelAPPWindow

Minimize the Excel Window and Activate the workbook. Return the name of the Excel App Window

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"