I am currently working on scenario where I want to classify relevant and irrelevant files and then copying the classified and unclassified files to the relevant folders. After copying I want to write those classified files to the excel workbook on Sheet1 with relevant files and on sheet2 with irrelevant files.
I have successfully copied the relevant and irrelevant files to the respective folders. But when I try to write files on excel sheet it doesn’t properly get written into excel file.
Any help in this regard will be highly appreciated.