<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
-->
</style><style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1" lang="EN-US" link="blue" vlink="purple">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi<br>
In 2.0 on my computer i works- Please remember to close the file in Excel before opening in QGIS - I get an Attribute table. If you want to open and use colums as x and y coordinates - Save your xls to csv and open as CSV.<br>
Regards<br>
Lene
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF138055"><font color="#000000" face="Tahoma" size="2"><b>Fra:</b> qgis-user-bounces@lists.osgeo.org [qgis-user-bounces@lists.osgeo.org] på vegne af Chrest, David [davidc@rti.org]<br>
<b>Sendt:</b> 5. november 2013 14:07<br>
<b>Til:</b> qgis-user@lists.osgeo.org<br>
<b>Emne:</b> [Qgis-user] Cannot add XLS table, no recognized data type<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal">The QGIS 2.0 User Guide states that I can add Excel (XLS) files like other layers and tables. Page 50 of Anita Graser’s Learning QGIS 2.0 book (great book by the way) also says “…we can load XLS files by simply dragging them into QGIS from
the file browser or using Add Vector Layer.” However, My .xls file does not appear in the file browser. And when I try to add it by other methods, I get the “…is not a valid or recognized data source” error message. Am I missing something obvious? Is there
something I need to do to be able to ad .xls tables that was not documented?</p>
<p class="MsoNormal">Thanks for any help.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">David</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">David Chrest</p>
<p class="MsoNormal">Research GIS Analyst</p>
<p class="MsoNormal">RTI International</p>
<p class="MsoNormal">3040 Cornwallis Rd, PO Box 12194</p>
<p class="MsoNormal">Research Triangle Park, NC 27709-2194</p>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
<br clear=all>
</body>
</html>