Can we read data from multiple Excel Files not Sheet

Can I read multiple excel files from Excel Application Scope, if not how can we do it

You mean to say Multiple excel sheets in a single excel or different excel ?
if different excel then you have to choose different excel paths.
Take a loop. Inside take an excel Application Scope.
Pass different excel file paths in different variables.
Change Variables in each loop so that Excel application scope will read different Excel File.

Hope my inputs are useful.

Yes different excel files, I have done it via looping it with different files names and then append the result into a single file.

Thanks for the prompt response.


Can you please share if any example file for the reference