topic Re: How to extract data from multiple sheets in excel into Qlikview with loops condition in QlikView https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962886#M330321 <HTML><HEAD></HEAD><BODY><P>Add this line to the script above the load statement that loads the data from the excel files:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET ErrorMode=0;</P><P>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.</P></BODY></HTML> Wed, 16 Sep 2015 15:26:14 GMT Gysbert_Wassenaar 2015-09-16T15:26:14Z How to extract data from multiple sheets in excel into Qlikview with loops condition https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962885#M330320 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have 4 excel files (.xlsx) ..in that excel files " <STRONG>in cell A5 " </STRONG>having the error .</P><P>While loading the excel file into qlikview , Find an error ?</P><P>How we can implement <STRONG> Looping for go to next File ? </STRONG></P><P>if an error will occur &gt; skip that excel file and go to next excel file ...</P><P></P><P>How can we implement ?</P><P></P><P>Thanks</P><P>Madhu</P></BODY></HTML> Wed, 16 Sep 2015 13:14:09 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962885#M330320 madhubabum 2015-09-16T13:14:09Z Re: How to extract data from multiple sheets in excel into Qlikview with loops condition https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962886#M330321 <HTML><HEAD></HEAD><BODY><P>Add this line to the script above the load statement that loads the data from the excel files:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SET ErrorMode=0;</P><P>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.</P></BODY></HTML> Wed, 16 Sep 2015 15:26:14 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962886#M330321 Gysbert_Wassenaar 2015-09-16T15:26:14Z Re: How to extract data from multiple sheets in excel into Qlikview with loops condition https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962887#M330322 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Follow Gysbert advice,</P><P></P><P>have a look:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4452">Load Multiple excel sheets using For loop</A></P><P></P><P>Hope it helps!!</P></BODY></HTML> Wed, 16 Sep 2015 15:51:34 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-multiple-sheets-in-excel-into-Qlikview/m-p/962887#M330322 Anonymous 2015-09-16T15:51:34Z