Oct-28-2019, 12:18 PM
Hi,
I have a folder contain multiple folders. Each of these subfolders contains an excel file. Is it possible to loop through each subfolder and create a single CSV from the data from a particular column from each xls file. If possible can I ensure that only excel filenames starting with a certain text are read?
Many thanks for any advice.
I have a folder contain multiple folders. Each of these subfolders contains an excel file. Is it possible to loop through each subfolder and create a single CSV from the data from a particular column from each xls file. If possible can I ensure that only excel filenames starting with a certain text are read?
Many thanks for any advice.