topic loading the data from Excel book with multiple sheets in QlikView https://community.qlik.com/t5/QlikView/loading-the-data-from-Excel-book-with-multiple-sheets/m-p/939781#M960568 <HTML><HEAD></HEAD><BODY><P>I have the data in sheet 1 , sheet 2 sheet 3 like this but&nbsp; column names having only in sheet 1&nbsp; so how can i load the data in the script</P></BODY></HTML> Wed, 21 Oct 2015 14:10:37 GMT 2015-10-21T14:10:37Z loading the data from Excel book with multiple sheets https://community.qlik.com/t5/QlikView/loading-the-data-from-Excel-book-with-multiple-sheets/m-p/939781#M960568 <HTML><HEAD></HEAD><BODY><P>I have the data in sheet 1 , sheet 2 sheet 3 like this but&nbsp; column names having only in sheet 1&nbsp; so how can i load the data in the script</P></BODY></HTML> Wed, 21 Oct 2015 14:10:37 GMT https://community.qlik.com/t5/QlikView/loading-the-data-from-Excel-book-with-multiple-sheets/m-p/939781#M960568 2015-10-21T14:10:37Z Re: loading the data from Excel book with multiple sheets https://community.qlik.com/t5/QlikView/loading-the-data-from-Excel-book-with-multiple-sheets/m-p/939782#M960569 <HTML><HEAD></HEAD><BODY><P>you load from sheet1 using file wizard from table files and define Embedded Labels</P><P>you load from sheet2 and sheet3 without labels</P><P>from sheet2 and sheet3 the scrpt Looks like</P><P>Load</P><P>@1,</P><P>@2,</P><P> etc.</P><P></P><P>you Need to give them the same column names manually</P><P>Load </P><P>@1 as ColumnName1,</P><P>@2 as ColumnName2,</P><P> etc.</P><P></P><P>I suppose that there is no automatic way</P></BODY></HTML> Wed, 21 Oct 2015 14:16:33 GMT https://community.qlik.com/t5/QlikView/loading-the-data-from-Excel-book-with-multiple-sheets/m-p/939782#M960569 Anonymous 2015-10-21T14:16:33Z