topic Re: Reading from Excel sheet in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759639#M1541 <HTML><HEAD></HEAD><BODY><P>You can use the Transformation options of the File Wizard to fill the empty cells. See attached video.</P></BODY></HTML> Thu, 18 Dec 2014 09:44:27 GMT Gysbert_Wassenaar 2014-12-18T09:44:27Z Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759638#M1540 <HTML><HEAD></HEAD><BODY><P>hi All</P><P>please I need your help</P><P></P><P>i am reading on Qlikview from an Excel Sheet but i am facing a problem.</P><P>how can i fill an empty Cell&nbsp; ex:</P><P>&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C</P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 192px; BORDER-COLLAPSE: collapse;"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl63" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">Jul-14</SPAN></TD><TD class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;"> </SPAN></TD><TD class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">Avg</SPAN></TD><TD class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">Int</SPAN></TD><TD class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">Rate</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl64" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">233</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">251</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl64" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">32</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">122</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">2133</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl64" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">123</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">131</SPAN></TD><TD align="right" class="xl64" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">131</SPAN></TD></TR></TBODY></TABLE><P></P><P>When i Importing this Form the first cell in column B and C is empty</P><P>the script will show like this</P><P>Directory;</P><P>Load</P><P>41650,</P><P>F2,</P><P>F3,</P><P></P><P>i need to show as</P><P>41650,&nbsp;&nbsp;&nbsp;&nbsp; </P><P>41650,</P><P>41650</P><P></P><P>Ps: i cannot change in the form of the excel sheet cause i have almost a hundred excel sheet same form so if i change one i have to change the others so it will take alot of time, i am looking for a solution using Qlikview,</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 18 Dec 2014 08:33:11 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759638#M1540 mario-sarkis 2014-12-18T08:33:11Z Re: Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759639#M1541 <HTML><HEAD></HEAD><BODY><P>You can use the Transformation options of the File Wizard to fill the empty cells. See attached video.</P></BODY></HTML> Thu, 18 Dec 2014 09:44:27 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759639#M1541 Gysbert_Wassenaar 2014-12-18T09:44:27Z Re: Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759640#M1542 <HTML><HEAD></HEAD><BODY><P>Gysbert Wassenaar thank you your Answer is helpful but i just realize that i have this case</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD></TR></TBODY></TABLE><P></P><P>and i need to Show like this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD></TR></TBODY></TABLE><P> without filling all Cells just in the first ROW !!</P><P>Help PLEASE!!! Can YOU!!!????</P></BODY></HTML> Thu, 18 Dec 2014 15:03:53 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759640#M1542 mario-sarkis 2014-12-18T15:03:53Z Re: Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759641#M1543 <HTML><HEAD></HEAD><BODY><DIV><P>Gysbert Wassenaar thank you your Answer is helpful but i just realize that i have this case</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; border-collapse: collapse; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-collapse: collapse; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD></TR></TBODY></TABLE><P></P><P>and i need to Show like this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; border-collapse: collapse; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-collapse: collapse; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; border-collapse: collapse; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-collapse: collapse; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD></TR></TBODY></TABLE><P>without filling all Cells just in the first ROW !!</P><P>Help PLEASE!!! Can YOU!!!????</P></DIV></BODY></HTML> Thu, 18 Dec 2014 15:15:58 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759641#M1543 mario-sarkis 2014-12-18T15:15:58Z Re: Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759642#M1544 <HTML><HEAD></HEAD><BODY><P>LOAD A, </P><P>&nbsp;&nbsp;&nbsp; if(RowNo()=1,A, B) as B, </P><P>&nbsp;&nbsp;&nbsp; if(RowNo()=1,A, C) as C </P><P>FROM [*.xlsx] (ooxml, no labels, table is Sheet1);</P></BODY></HTML> Thu, 18 Dec 2014 15:25:09 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759642#M1544 Gysbert_Wassenaar 2014-12-18T15:25:09Z Re: Reading from Excel sheet https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759643#M1545 <HTML><HEAD></HEAD><BODY><P>sorry Gysbert For disturbing you</P><P>if i have it like this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192pt; border-collapse: collapse;" width="256"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;"> </SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41253</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">5211</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">331</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">16</SPAN></TD></TR></TBODY></TABLE><P></P><P>need to show it like this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192pt; border-collapse: collapse;" width="256"><TBODY><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="background-color: transparent; width: 48pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41565</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41253</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">41253</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">231</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">23</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">5211</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">331</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">21</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">12</SPAN></TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">16</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 18 Dec 2014 15:33:27 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Reading-from-Excel-sheet/m-p/759643#M1545 mario-sarkis 2014-12-18T15:33:27Z