how to give border by using UiPath dynamically without mentioning the range of excel
FROM range is available but TO range is not available
1 Like
In use excel Excel.Sheet("Sheetname").FullRange will give the filled range in the sheet which cna be used in the activity
Cheers
1 Like
I have start range but dont know end range
example a21 is start and in k index i dont know the how many rows are there in k
I have specified the count but its is going to top rows but I want down rows
In which activity should I write this expression
You dont need to use the above formula also …direclt save this vba in .vba file and use invoke vba and pass the sheetname as inout parameter…it would add boarders as needed
How to configure
It gives return value aslo success when sucessful else the error message
cheers
1 Like
You can follow below process. This is apply borders. Pass the file path in Use Excel File. In Invoke VBA download the text file path and pass the path in Code file path and Entry Method Name as ApplyBorders. This should help you.
Input.txt (534 Bytes)
If you face any difficulties, please provide the input file and where to apply borders. I will help you out.
Regards
where can I declare the start cell here
You need not declare it would find the first filled cell and would start applying borders from there
Cheers
Input (1).txt (539 Bytes)
After running the process below is the output.
Book 1 (1).xlsx (13.1 KB)
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.