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.
WorkbookPath - Type String - Mandatory
VisibleSheets - Type list<String> - Optional
Put this activity inside a sequence or flowchart (Excel Application Scope is not required). Pass the absolute path to the Workbook as Input WorkbookPath and assign output VisibleSheets to a variable of type list<String>.
You can iterate through list<String> using For Each activity and get the name of all visible sheets.
This activity 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.