How to click in Excel: "Home" --> "Format" --> "AutoFit Column Width"

[Erik_S]

Hi all,

I have problems automating click “Home” → “Format” → “AutoFit Column Width” in Excel.

What I tried:

• Click Button activities → Cannot select “AutoFit Column Width” as it is in a drop down menu
• Type Into activity with “[d(alt)]hoi”+”[u(alt)]" → works as long as I watch the bot. But as soon as I minimize my server, Type Into activities do not work for me anymore
• Send hotkey activity with “Alt + hoi”–> Only “h” and “o” are pressed, “i” for some reason does not work

Not sure what I am doing wrong. Please share your ideas!

[Eric_Wong_Test (Eric Wong)]

You can download BalaReva.Excel.Activities. It has an AutoFit Column Activity that can use

[chaitanya.kulkarni]

Hello,

Are you using unattended bot license? If yes, try to check ‘Send Window Message’ checkbox or ‘Simulate Type’ checkbox for ‘TypeInto activity’.

BR,
Chaitanya

[Erik_S]

Yes I am using an unattended bot. Tried both and tested attendedly first:

‘Send Window Message’ → Works partly: I can see that “h” and “o” are pressed, but I am not sure if “i” is also pressed, as the dropdown from the ribbon disappears in just a few milliseconds and the columns are still not adjusted. (Without “Send Window Message” it works fine attendedly). I think “Send Window Message” could be the way to go, but something is still wrong here

‘Simulate Type’ → Instant Error message “Cannot use UI_CONTROL_API on this UI node. Please use UI_HARDWAREEVENTS method”

[prasath_S]

Hi @Erik_S

You can use invoke vba activity for this,

VBA_Script.txt (103 Bytes)

Before run change this settings one time in excel.

In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel ( File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box).

In excel application scope pass your excel name

[prasath_S]

HI @Erik_S

is your issue fixed ?

[balupad14 (Balamurugan)]

Hi @Erik_S ,

Take a look at this

BalaReva.Excel.Activities Continue

Hi Friends, I have included some new activity in the package (AutoFitColumns,AutoFitRows,Format Cells). Now you can get the package here. I have uploaded the package in the UiPath Go. After It is uploaded , I will remove the package from here. Namespace : [image] AutoFitColumns Properties : [image] Usage of Column Range Single Column = { “A:A” } Continuous Columns={“B:D”} Multiple Columns ={ “A:A”,“D:D”, “E:G” } Range of Cells ={“A1:D8”} To set column width AutoFit=False ColumnWi…

Regards
Balamurugan.S

[Shagoul_Hameed]

Hi prasath_S

can you please advise on this post

How to apply auto fit for the merged columns [Excel]

Hi MY, Thank you for the response, I’ve read this post this for to merge & unmerge the cells. In my case the excel file already merged with few columns as I mentioned above. I want only apply the “auto fit for the merged columns”. Shagoul

[Aleem_Khan (crazy bot)]

Enable simulate click

[Sudharsan_Ka]

Hi @Eric_Wong_Test

Try this Enable modern design

• Excel Process Scope Activity
  • Use Excel File
    • Autofit (You can choose row or column or both and range also can be specified)
      
      
      
      
      

Hope this Helps

Regards
Sudharsan