topic Re: Load multiple sheets from a single Excel file in QlikView

topic Re: Load multiple sheets from a single Excel file in QlikView https://community.qlik.com/t5/QlikView/Load-multiple-sheets-from-a-single-Excel-file/m-p/1073778#M935008 <HTML><HEAD></HEAD><BODY><P>See this example: <A href="https://community.qlik.com/message/725647">Re: Loading Multiple Excel Files and Multiple Excel sheets</A></P></BODY></HTML> Sat, 20 Feb 2016 10:07:22 GMT Gysbert_Wassenaar 2016-02-20T10:07:22Z Load multiple sheets from a single Excel file https://community.qlik.com/t5/QlikView/Load-multiple-sheets-from-a-single-Excel-file/m-p/1073777#M935006 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">I have an excel file “Knowledgebase” which has several sheets</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><STRONG style=": ; color: #000000; font-size: 12pt; font-family: Calibri; text-decoration: underline;">SHEETS</STRONG></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">“Device”</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">“Networking”</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">“Offline”</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">All sheets have the exact same Column headings </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><STRONG style=": ; color: #000000; font-size: 12pt; font-family: Calibri; text-decoration: underline;">COLUMN HEADINGS</STRONG></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Category </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Problem </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Occurs</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Resolution</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Date</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><P style="margin: 0px 0px 10pt;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">I am able to load each sheet separately. However, I am wondering if there is a way to load multiple sheets from a single Excel file?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P></BODY></HTML> Fri, 19 Feb 2016 14:49:25 GMT https://community.qlik.com/t5/QlikView/Load-multiple-sheets-from-a-single-Excel-file/m-p/1073777#M935006 mwscott1 2016-02-19T14:49:25Z Re: Load multiple sheets from a single Excel file https://community.qlik.com/t5/QlikView/Load-multiple-sheets-from-a-single-Excel-file/m-p/1073778#M935008 <HTML><HEAD></HEAD><BODY><P>See this example: <A href="https://community.qlik.com/message/725647">Re: Loading Multiple Excel Files and Multiple Excel sheets</A></P></BODY></HTML> Sat, 20 Feb 2016 10:07:22 GMT https://community.qlik.com/t5/QlikView/Load-multiple-sheets-from-a-single-Excel-file/m-p/1073778#M935008 Gysbert_Wassenaar 2016-02-20T10:07:22Z