Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I have to read a lot of excel files, but this load have a particularity. Each excel file may have or not a sheet called "USD". So If this file have this sheet I have to read all the data, and if not I have to pass to the other one and do the same process until complete all the files. I know how to process multiple files but I don't Know how to control the script execution using a control for the Sheet name.
Please give me and idea with that !!
Best Regards!
Carlos
Hi Carlos,
Add below script:
SET ErrorMode=0;// this will ignore error if excel workbook has no USD sheet
for each vFileName in FileList('D:\Pactise\Community\New folder\*.xlsx');
LOAD *
FROM
$(vFileName)
(ooxml, embedded labels, table is USD);
next
Please let me know if this not working.
Regards,
Pankaj