How to Hide and Unhide columns in excel sheet

Learning Initatives Automation Starter
, , ,
1

How to Hide and Unhide columns in excel according to time. IF my systeam time 11:00 AM then 9:00 AM to 11:00 AM column is unhide and all other time columns is hide. Please find excel snap shot.
image

2

Hello @Mohammed_sahil

There are no default packages available for this. Either you use it via VB script or you can use the below custom package.

3

@Rahul_Unnikrishnan Thank for your support but i already use this activity. if i using this activity in only single sequence then is working and if i use this activity in main workflow then it’s not working.

4

@Mohammed_sahil

Sorry… i didnt get it… Can you share the screenshot of the working and non working scenario

5

@Rahul_Unnikrishnan please discribe VB script. what condition i use in this workflow?

6

It is single sequence screenshot. it is working.

image
image724×475 12.1 KB

7

image
image714×506 15.3 KB

8

ok…so in the non working scenario whats the error that you are getting?

9

and non working workflow screenshot is in this sequence

image
image716×511 12.8 KB

10

working scenario put in this workflow then it is not working

image
image709×509 13.3 KB

11

Plz share the error that you are getting.

12

i not get any error. if i run this activity in single then it’s hide perticular column and if i run this activity with all over workflow then it’s not working.

13

Hi @Rahul_Unnikrishnan
I am getting “Hide Columns: Exception from HRESULT: 0x800A03EC” error.