Excel Column Bold

[Robotics (Bala)]

Hi Team,

How to make the excel column header in bold.
Account Number Name
12345567890 XYZ

How to make the Account Number and Name column to display in bold?

[Sudharsan_Ka]

Hi @Robotics

You can try with format cells of modern activities checkout this

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @Robotics

Go to → Activities Panel → Click on Filter → Select Show Modern.

You can try with Format Cell activity

Regards
Gokul

[Robotics (Bala)]

In Filter not getting option as - Show Modern

[Gokul001 (Gokul Balaji)]

Just search for the activity @Robotics

Regards
Gokul

[Sudharsan_Ka]

Can you share the screenshot? @Robotics

[Robotics (Bala)]

Format cells also not found in activity. Only Format value is there.

[Sudharsan_Ka]

What uipath version are you using? @Robotics

[Robotics (Bala)]

Its 2019.10.5

[Sudharsan_Ka]

Modern activities will be available only in the higher versions @Robotics

[Robotics (Bala)]

Ok any other alternate there ?

[Gokul001 (Gokul Balaji)]

HI @Robotics

Check out this thread

How to Make Spesific Excel Rows Bold

Hey @mazlumkacar What you can do is… Use excel application scope and open the excel file. In that use a read range to read the data so that you can get the number of rows… use a for each row loop and loop through… within the loop, have a variable that increments in each iteration. This variable can be used to identify the row number… have a if condition to check whether the current row has the required value if true, use select range activity and specify the range and highlight that row. You …

How to make a particular row in excel bold

Here I need to make a particular row bold. The index of row is passed as a variable named totRange. i.e Sub CalcBold() Rows(“17:17”).Select Selection.Font.Bold = True End Sub instead of 17th row, I need to pass variable totRange. How to write the macro?

Hope it will helps

Regards
Gokul