Skip to Content

How to loop thru multiple folders where each folder has multiple excel files

Jul 01, 2017 at 02:39 PM


avatar image
Former Member

Hi DS Gurus. I have three folders ( Folder1…Folder3) and for each folder I have multiple excel files(similar file format) which need to be loaded to HANA. I need to loop thru all the three folders and load all the excel files to HANA. Each folder has a set of excel files which are of unique file formats. There is every possibility that a new folder can get added and looking for automating this as well. Please advice. Thanks!

Folder1 -> Fileformat1_1.xls

Folder1 -> Fileformat1_2.xls

Folder2 -> Fileformat2_1.xls

Folder2 -> Fileformat2_2.xls

Folder3 -> Fileformat3_1.xls

Folder3 -> Fileformat3_2.xls

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers