Get names of only visible sheets of an Excel file

Help Activities
, , , ,
1

Hello,

I am currently working on a process which uses Excel files as an input. There can be numerous sheets per file, and I need to get data from each sheet and merge them into one sheet before doing anything.

I built logic to pick up each sheet within the Excel file and read data, but I have noticed that there are a few hidden sheets in the excel file that get picked up which I don’t want to read. Is there any way of skipping over these hidden sheets?
image

Thanks in advance!

2

Hi @william.coulson

Check with the package from the Market place!

image
image1348×753 38.4 KB

Regards

1 Like
3

Hi

Have a view on this component

@william.coulson

1 Like
4

Hi @pravin_calvin, @Palaniyappan,

Thanks for this, it works well! :smiley:

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.