This content has been marked as final. Show 4 replies
I manage to load information from all excel files in folder by using this script:
SUB DoDir(Root) FOR each File in filelist( Root & '\*.xls') LOAD @1, @2 FROM [$(File)] (biff, no labels, table is Sheet1$); NEXT File FOR each Dir in Dirlist (Root&'\*') CALL DoDir(Dir) NEXT Dir END SUB CALL DoDir('C:\Users\Mindaugasb\Desktop\Orders\2016')
Now how should I change the script to load information from different sheets in the files?