How to do autofit and bold specific column for excel in uipath?

excel
uiautomation
uipath

#1

Hi,

I want to do autofit for specific columns and bold for header column, how can i do that using uipath?


#2

Hi,
Try in Excel scope, put send hot keys) allways works)


#3

@Vladokrash thanks but i tried it is not working, do you know the keystrokes for autofit columns?


#4

try this, use Excel scope, check in properties visible, select range with activity, then put hot keys “alt+h”, them “o, i”.


#5

thank you


#6

I have a lot of success using TypeInto with the hotkey combinations, and it’s super fast; you can also combine combos, like rename sheet and type in the sheet name in one line.

Examples,
TypeInto "[k(alt)]horName[k(enter)]"
Select Range … TypeInto “[k(alt)hoi[k(alt)]h1”

Can do both actions in one line too.

To find further key combos, just press the Alt key in Excel and you’ll see the characters popup in the menu.


#7

@ClaytonM thanks for the response, can i know what will be used for bolding the first col in excel?


#8

Hi,

You need to Select the column, then use the key combination (which you can find by pressing the Alt key followed by the characters that display on the menu ribbon bar)

For example,
Select Range "A:A"
TypeInto “[k(alt)]h1”

That should highlight column A then do the combination for Bold.

Regards.


#10

Hi,

How to do autofit for entire coloumn for excel using uipath?