excelrpauipathuipath-studio
WorkBookPath property is not available in UiPath Studio
I am working on one project in UiPath Studio. I am not able to find WorkbookPath option in Read Range activity. Is there any other option, from where I can browse my XLSX file in Read Range activity. Please check attached screenshot.
Solution
The Read Range activity must be within the Excel Application Scope (see the red message on the right upper side).
So simply delete both activities above the scope and use the existing Read Range on the bottom of your image.
Before that, select the Excel Application Scope and set the parameter Workbook path to your Excel file.
Now the Read Range works properly.
And if you need 2 different Excel files, just create another scope for that one.
- Move values from column to rows in Excel
- Application.FileDialog vs GetOpenFilename: What is the difference?
- Only display the values in a certain rank position from filtered and sorted list
- Convert table to reflect column names as row values
- Excel: Dynamic stacking or arrays n-number of times
- Convert Excel formula to Power Query (if countifs)
- Trying to hide rows in excel based on two values
- Combine every unique value from column A with duplicated values into a new sheet
- Import formula from variable - Excel VBA
- VBA Macro to detect unique entries and copy them from one workbook to another is copying a small fraction of duplicates along with the uniques
- Copy paste cells from button row
- Get the value of the second non-empty cell in a row
- SUMIF with UNIQUE criteria for multiple columns, adding all values with same name
- How can I use filter function in Excel to filter based on selections including those that are "ALL"?
- Openpyxl - I can't set cell format and sum values correctly in time format (h:mm)
- how to mask hash users into random values [email protected] in azure databricks
- Find/Replace Row number within Formula
- Extracting & summing data from a single cell in excel
- How to map table references in a JSON file to corresponding values in an Excel file using Python?
- Conditional Formatting to highlight current date on calendar
- Convert number in excel to M or B
- How to have instructional text in Excel?
- How to copy a range to several worksheets by using a list of worksheets to copy to
- VBA - exclude certain boxes from a general check
- How to count resolved comments only via VBA in Excel
- Excel VBA - how do I get the RowSource of a ComboBox to change depending on the value of another Combobox?
- check if a file is open in Python
- How to copy only plain text of cells in Excel?
- VBA - Capitalise range of cells before the last period
- Getting the next value of the same user if the type is "no type"