How to hide Columns in Xl dynamically

excel
activities

#1

Hi Team

I am trying to do the following things i

  1. open xl file from a folder which has more than 10 excel sheet.
  2. Open each file and hide some column in that xl file.

I am able to so the first one, but not able to get any function for second one… Is i am missing any key function. Any help wil be much appreciated.

Regards

SS


Simple excel exercise
#3

Hi there!

Could you hide columns with uipath? Because I am trying to do the same thing…

Thank you!


#4

HI @Mr_Robot,

use excel application scope.
Select the column and use send hot key-> Ctrl+0 for Column hide Ctrl+9 for Row hide.

Regards,
Arivu


#5

And this is by Invoke Code, @srirseshadri @Mr_Robot :

Worksheet.Range("B:B").EntireColumn.Hidden = True

Sample here: (reuploaded) Hide Column.zip (8.6 KB)


#6

In your sample when I download it doesn’t work."


#7

@Mr_Robot whoops. Reuploaded, please kindly check it.


#8

Hi @srirseshadri,

It is a package that to hide and un-hide columns and rows.

Regards
Balamurugan.S