Sign In
Create your first automation in just a few minutes.Try Studio Web →
Get Visible Only Worksheets
by YouTube
0
Activity
<100
Summary
Summary
Get a list of visible only worksheets from an Excel workbook
Overview
Overview
This activity is designed to find the list of visible only worksheets from an Excel workbook. It supports one Input Argument and One Output Argument.
Input:
WorkbookPath - Type String - Mandatory
Output:
VisibleSheets - Type list - Optional
Operation:
Put this activity inside a sequence or flowchart (Excel Application Scope is not required). Pass absolute path to Workbook as Input WorkbookPath and assign output VisibleSheets to a variable of type list.
You can iterate through list using For Each activity and get the name of all visible sheets.
It has been tested with .xlsx and .xls workbook types with MS Excel 2013.
Features
Features
This component is useful when visible only worksheets from an Excel workbook are required. It is minimal and easy to integrate with the existing workflow by simply drag and drop.
Additional Information
Additional Information
Dependencies
MS Excel
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
Apache
Privacy Terms
Technical
Version
1.3.0Updated
February 18, 2020Works with
Uipath Studio 2018.2.3 Stable
Certification
Silver Certified
Application
Support
UiPath Community Support
Similar Listings
