How to get the visible range of excel without hidden rows. In the excel range I have to get the rows upto Total and columns upto %Total and avoid hidden rows
Hello @anjani_priya,
use the Read Range activity with the “Visible cells only” option enabled. Find the last row (Total) and last column (%Total) dynamically:
- Search for ‘Total’ in rows → ‘intLastRow’.
- Search for ‘%Total’ in columns → ‘intLastColumn’.
Pass this range to Read Range (Visible only) → it will read only visible rows/columns, stopping at Total and %Total.
Hi @anjani_priya
you can try VBA in UiPath that would be better approach
Use Excel Application Scope and pass your excel file and inside excel application scope use VBA Activity and pass this file path for VBA
In Parameters
pass the SheetName{ “Sheet1”, visibleRange }
Function GetVisibleRange(sheetName.txt (751 Bytes)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.