How to add border to Excel rows

[RishiVC1 (Rishi Shukla)]

Hi, I’m trying to add a border to a particular range in excel while writing them. I’m quite new to Uipath and C#. I managed to find the below resource, but I’m not quite sure how I can apply this logic in UiPath.

How can a border be set around multiple cells in excel using C#.

Please guide me.

Thank you

[Pankaj.Patil (Robot Master)]

Please read this,

How can a border be set around multiple cells in excel

There is no direct way of doing this. You can create a macro and run the macro from UiPath to get this done.

[RishiVC1 (Rishi Shukla)]

I know, That’s why I attached the resource stating how we can assign the border in Excel using C#.

Here is the link:

How can a border be set around multiple cells in excel using C#.

Any Ideas how can I incorporate it into my flow?

[Pankaj.Patil (Robot Master)]

Please download both files(xaml and macro file),
Excel save.xaml (8.3 KB)Set Border.xlsx (9.0 KB)

save Set Border.xlsx file as Set Border.xlsm
and run.

[RishiVC1 (Rishi Shukla)]

hi, when I’m opening Set Border after changing its extension I’m getting an error saying file may be corrupted.

[Pankaj.Patil (Robot Master)]

Ok… No worries.

1. please create excel as *.xlsm,
2. go to developer tab,
3. click on macros and create new macro and
4. Paste below code, save it and run it

Sub setBorder()
Dim rang As Range
Set rang = Worksheets(“Sheet1”).Range(“A1:B4”)
With rang.Borders
.LineStyle = xlContinuous
.Weight = xlThin
End With
End Sub

Regards,
Pankaj

[RishiVC1 (Rishi Shukla)]

Hello @Pankaj.Patil,
thank you, But what if we aren’t allowed to run the macro on the target machine? I want something that can be written like set colour activity for cell or range.

Any guesses there?

Thanks

[Pankaj.Patil (Robot Master)]

Hello @RishiVC1,

It’s enough simple. please download xaml and excel files below,
Report.xlsx (7.8 KB)
Main.xaml (7.3 KB)

Regards,
Pankaj

[RishiVC1 (Rishi Shukla)]

@RishiVC1

I want something that can be written like set colour activity for cell or range.

what I meant that there should be an equivalent solution for setting up borders as compared to setting colour.

[mitesh_parmar]

@RishiVC1

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed a new activity to set the border to the range or cell inside the workbook. [image] Properties : [image] Detail of the properties Presets : [image] Line Style : [image] Border Color : You can set the color like .“Color.Red”. Border weight : you can specify the border weight like 4. Thank you Balamurugan.S

Use this activity it has set border activity in it.

[balupad14 (Balamurugan (BalaReva))]

Hi @mitesh_parmar.

Thank you.

[winnie_toh]

hi thank you for the activity! system will prompt that excel found is found, do i want to overwrite it. as there are a few worksheets in an excel file that i need to draw borders. anyway to remove the prompting?

[winnie_toh]

sorry the one i tried out was from below: (didn’t work though)

[balupad14 (Balamurugan (BalaReva))]

Hi @winnie_toh ,

Try this

How to add border to Excel rows

@RishiVC1 Use this activity it has set border activity in it.

Regards
Balamurugan.S

[winnie_toh]

dear @Balupad14 thank you for your help!
in the end, i created table instead, and there will be default borders and colors. so it resolved my needs. thanks again!

[Kia1 (Ana)]

@Pankaj.Patil

click on macros and create new macro and

how to click on macros and create new macro
can you give an example in the form of a picture?