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?
Thanks in advance!