topic How to load the range of rows of an excel sheet? in QlikView https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405937#M151050 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an excel sheet with 3 differant datasets in differant ranges.</P><P></P><P>Now how can i specify the range of data to load any particular data of the excel file into qlikview ?</P><P></P><P>For your referance,Please check the attachment.</P><P></P><P>Thanks for any help..</P><P></P><P>Regards</P><P>Kumar</P></BODY></HTML> Fri, 29 Mar 2013 06:50:42 GMT 2013-03-29T06:50:42Z How to load the range of rows of an excel sheet? https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405937#M151050 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an excel sheet with 3 differant datasets in differant ranges.</P><P></P><P>Now how can i specify the range of data to load any particular data of the excel file into qlikview ?</P><P></P><P>For your referance,Please check the attachment.</P><P></P><P>Thanks for any help..</P><P></P><P>Regards</P><P>Kumar</P></BODY></HTML> Fri, 29 Mar 2013 06:50:42 GMT https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405937#M151050 2013-03-29T06:50:42Z Re: How to load the range of rows of an excel sheet? https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405938#M151051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find here the attached file for the solution.</P><P></P><P>Regards,</P><P>Udit</P></BODY></HTML> Fri, 29 Mar 2013 07:15:09 GMT https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405938#M151051 udit_kumar_sana 2013-03-29T07:15:09Z Re: How to load the range of rows of an excel sheet? https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405939#M151052 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use transformation steps which are availble during loading of excel sheet.</P><P></P><P>Regards,</P><P>Amay</P></BODY></HTML> Fri, 29 Mar 2013 07:25:18 GMT https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405939#M151052 2013-03-29T07:25:18Z Re: How to load the range of rows of an excel sheet? https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405940#M151053 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you know the start and the end point of the data set. you can get the data fo the data set.</P><P></P><P>please check out the file attached.</P><P></P><P></P><P>Thanks,</P><P>Sampath</P></BODY></HTML> Fri, 29 Mar 2013 07:55:22 GMT https://community.qlik.com/t5/QlikView/How-to-load-the-range-of-rows-of-an-excel-sheet/m-p/405940#M151053 2013-03-29T07:55:22Z