Extract Column Names from each xlsx file in the directory

Question

Hello Experts,

I'm looking to extract column names from each of the xlsx file that are stored in the folder path in various folders and also find the sheet name.

I have reviewed posts within the community but couldn't find any related to my issue. I was able to pull in data until here and don't know how to get beyond this:

alexnajm · Accepted Answer

You also need to make sure you have the sheet names in the file path field that you pass into your Dynamic Input: The Ultimate Input Data Flowchart