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.
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