I read the data from 5 excel files using this: allFiles = directory.getfiles(“My files path”).
And then filtered data using filter datatable. I inserted the sorted data into separate file.
Now how do I check which file from 5 files does not have data based on my filter data table. If any of file does have data according to filtered condition, I need to get the name of that file & insert that file name into empty sheet.