How to change font size and font style of an Excel?

Help Studio
, ,
1

How to change the font size and font style (font name) of an Excel?

2

Hi @Rajat_Hedaoo

Can you share a sample excel file and let us know which font size and style you need to change in the file? So that we can help you on the same.

3

Hi @Manish540

We can take any Excel file for sample, the font name should be set to Arial and font size should be 8. This has be done without using the Modern activities.

Thanks

4

@Rajat_Hedaoo

So, you have to change the font size and style of range of cells(For example:- “A1:C10”) or of a single cell(For example:- “A1” or “B1”)?

5

Hey

please check this balareva guide, you can make that with his activities

Regards

6

HI @Rajat_Hedaoo

You can use Format cells activity in Modern Design

image
image962×688 33.5 KB

Regards
Sudharsan

7

Why @Rajat_Hedaoo any specific reason?

8

For the whole of excel

9

Hi @Sudharsan_Ka

It is an old project and due to limitation of organization I cannot use Modern activities.

Thanks

10

Hi @fernando_zuluaga

I am limited to using only UiPath extensions. I cannot use any external extensions for the same.

Thanks

11

Then the only option is using an invoke code from vba, here are some exampels

12

@Rajat_Hedaoo Please find the below workflow attached,

Uipath_ChangeFontSizeAndStyle.zip (10.3 KB)

And if you have any issue in running the vba then check below settings has been enabled in excel application - trust center.
image

Hope this may help you :slight_smile: