How to extract data from multiple sheets in excel into Qlikview with loops condition

[madhubabum]

Hi All

I have 4 excel files (.xlsx) ..in that excel files " in cell A5 " having the error .

While loading the excel file into qlikview , Find an error ?

How we can implement Looping for go to next File ?

if an error will occur > skip that excel file and go to next excel file ...

How can we implement ?

Thanks

Madhu

[Gysbert_Wassenaar]

Add this line to the script above the load statement that loads the data from the excel files:

     SET ErrorMode=0;

That will tell Qlikview to ignore all script errors. You can turn error handling back on with another line SET ErrorMode=1; after the load statement.

[Anonymous]

Hi,

Follow Gysbert advice,

have a look:

Load Multiple excel sheets using For loop

Hope it helps!!