How to use StudioX to hide columns in Excel?

Help StudioX
,
1

Hi all,

I’m currently working on some Excel reports, how can I use StudioX to hide some columns in Excel?

Example: If A2 is empty, hide col. C

Thanks in advance!

2

Hi @lun950831

Use Excel Application Scope activity.
Select the column and use send hot key → Ctrl+0 for Column hide Ctrl+9 for Row hide.

Regards
Gokul

3

Hi @Gokul001,

Thanks for your reply, would you please explain more about how to select the specific column?

Do you mean there is a “Scope” activity under Excel Application? I can’t find it~

Thanks.

4

Hi @lun950831

There is an For Each Excel sheet Activity

image
image875×369 5.69 KB

Regards
Gokul

5

Is this available in StudioX?

Question is about how to use Hide columns in StudioX… Please refer to the question posted by the user again…

6

@Gokul001 - Since there is no activity to hide columns in StudioX directly…I have used UI Automation to achieve it …Please check below…

image

image
image623×580 20.4 KB

image

2 Likes
7

Hi @prasath17

Great! this is a possible solution at this moment! Hope the hide col/row function will be added to the StudioX Excel activity soon.

Thanks a lot.