So this is the scenario
I have an excel opened at run time . Now i dont know how many rows it has , how many cols it has.
All i need to do is
- Towards the end or anywhere in the sheet , create a new column
- In the second cell of that column, apply a formula.
- Drag that formula down until the last row.
Now please remember i dont know how many rows or cols the sheet has . So i am looking for a way to use the activity in uipath and get it done.
A little reluctant to use data tables and row count or col count etc.
Please shoot in your ideas