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