How to give border by using uipath dynamically

how to give border by using UiPath dynamically without mentioning the range of excel
FROM range is available but TO range is not available

@anjani_priya


AppluBoarders.txt (225 Bytes)

Output :

1 Like

@anjani_priya

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

@anjani_priya

Did you try the above expression?

Cheers

In which activity should I write this expression

@anjani_priya

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

Hi @anjani_priya

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

@anjani_priya

You need not declare it would find the first filled cell and would start applying borders from there

Cheers

Hi @anjani_priya

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.