24a493c9-30fd-41e1-9f80-882c55335767.jpg

RPA Developer 

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 - MandatoryOutput:VisibleSheets - Type list&lt;String&gt; - 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&lt;String&gt;.You can iterate through list&lt;String&gt; 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.

Get a list of visible only worksheets from an Excel workbook

Many times in an automation file downloads are required. It is a tedious task to download file by navigation to URL, then Selecting download path and file name. It is also error prone and requires rework when Internet Browser version changes on different OS environments.This component is helpful in such scenarios as it does not require GUI automation (unless Authentication is necessary).INPUT:FileURL - Type String - MandatoryLocalFilePath - Type String - MandatoryUseBrowserAuthentication - Type Boolean - MandatoryUseDefaultProxy - Type Boolean - MandatoryOUTPUT:Result - Type Boolean - Optional Operation:Provide Source URL in File URL, provide Local Path (Absolute or Relative) in LocalFilePath.Provide True in UseBrowserAuthentication if file download requires authentication (this component uses cookies to authenticate. Authentication should be done in IE browser using GUI automation i.e. login to website/application) else provide False.Provide True in UseDefaultProxy to use default proxy settings else provide False.

About me

Get Visible Only Worksheets

Download File