How to get only unhidden sheet names in excel

Help Studio
, ,
1

Hello ,

I am using Get workbook sheets activity, but it is providing me the names of all hidden and unhidden sheets. I want only unhidden sheet names.
Can someone please help me with this issue.

Thanks

2

Hi @Akanksha_Patil1 ,

Welcome to the community.

Please use this custom activity…It will solve your problem.

3

Hello @Akanksha_Patil1

As per my understanding you cannot achieve this with the default excel activities. Instead, you can use the custom activity as mentioned in the below post.

Thanks

4

Hi @Akanksha_Patil1 ,

Alternately, we could use Invoke Code Activity to get the Sheet names (Visible/Hidden) using Interop.Excel
Could you Check the below workflow :

Excel_Get_HiddenAndUnhiddenSheets.zip (13.1 KB)

Let us know if this doesn’t help.

1 Like
5

@Akanksha_Patil1

6

Hey @Akanksha_Patil1 Try this workflow
Don’t forget to change the file name in the invoke code arguments
ExcelSheetNames.zip (8.8 KB)

Regards
Sreejith S S