Thank you in advance for helping me out on my query.
I have a requirement where I have multiple CSV files downloaded from a web service and I need to write the data in these files to different excel sheets.
File 1.csv to A.Xls, 2.csv to B.xls and so on, the file CSV and XLS file names are dynamic in nature.
I am stuck at creating a loop wherein 1.csv is read and wrote to A.xls and then continue with the next file.
Can one you kindly help me out in how I can get this created?