Extract Column Names from each xlsx file in the directory

[geeklarokcmie]

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]

You need to select your path field under "Read a List of Data Sources"

[alexnajm · Accepted solution]

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