Get File names and read excel as DT and the excel sheet will vary?

In a folder, there are multiple excels

I’m able to get file names, and I’m passing the file name as excel application scope to open the excel and read as data table
but, it shows empty excel.
why??

1)How can I read as each excel as data table variable in a folder
2)And also the sheet name will vary for very excel.

Please help out

@sudhasagar Are you sure that these excel files have data in them?

If there is, are you passing the name of these files properly?

1)How can I read as each excel as data table variable in a folder?

Once you have a list of names, depending on how you are saving this list, Array or Table. Use a For Each or For Each Row activity with an application scope nested inside. Use the Item or Row.Item to open the excel document and save to a table… Do what you want with the data.

@sudhasagar if you read csv file - you need to use “read csv” activity

csv can also open as excel application scope