How to read Excel file dynamically?

[aksh1yadav (AKSHAY YADAV)]

Hey @kirti9000

You can Read all files exists into a directory by using Directory.GetFiles(FOLDER_PATH+"\INPUT\","*.*",SearchOption.AllDirectories)

Then inside for each you can make a condition to read only excel files like this

Path.GetExtension(item)=“.xlsx”

For more assistance see below screenshot.

Regards…!!
Aksh