Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ce_gutierrez
New Contributor III

How to control Excel File Load

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

Tags (1)
1 Reply
passionate
Valued Contributor

Re: How to control Excel File Load

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