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" |
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