<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.yiv5339078243hoenzb
{mso-style-name:yiv5339078243hoenzb;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Comic Sans MS";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">Well, you can do this with DBF files, which Excel can open and save (part of a SHP). Or are you trying to save the spatial aspects in a tabular manner?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">Bobb<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Brent Wood<br>
<b>Sent:</b> Tuesday, November 05, 2013 1:41 PM<br>
<b>To:</b> G. Allegri<br>
<b>Cc:</b> qgis-user@lists.osgeo.org<br>
<b>Subject:</b> Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="color:black">Cheers...<br>
<br>
I don't want to create shapefiles or csv's, etc, from spreadsheets, I just want to plot *.xls files which contain x/y columns on the map.<br>
<br>
I sort of figured that if a GIS tool can open an xls file this would be pretty basic functionality... perhaps optimistically :-)<br>
<br>
The use case I'm envisaging is a live Excel spreadsheet used to store data. New rows (records) are added as appropriate. A QGIS project includes the spreadsheet as a current layer - so a QGIS user can open the spreadsheet, as well as other map layers, & save
the project. Reopening the project would automatically plot all the rows in the spreadsheet on the map.<br>
<br>
The only ways I can see to achieve this functionality involve recreating another copy of the spreadsheet in another format before I can view the points on the map. Which is an annoying extra few steps every time I want to view the spreadsheet.
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Is this worth filing a ticket for? Perhaps add some extra functionality in the vector layer dialogue: if the file type opened is an xls, allow the user to (optionally) specify the column
identifiers for the X & Y coords & the SRID to apply? <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Brent Wood<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="color:black">
<hr size="1" width="100%" align="center">
</span></div>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">From:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"> G. Allegri <<a href="mailto:giohappy@gmail.com">giohappy@gmail.com</a>><br>
<b>To:</b> Brent Wood <<a href="mailto:pcreso@pcreso.com">pcreso@pcreso.com</a>> <br>
<b>Cc:</b> "<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>" <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>>
<br>
<b>Sent:</b> Wednesday, November 6, 2013 8:15 AM<br>
<b>Subject:</b> Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
<div id="yiv5339078243">
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">I don't know if there's a plugin for that. <o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Otherwise you could use Processing. Under QGIS geoalgorithms -> Vector creation tools you find Points layer from file. If you right click on it and choose Execute as batch process, you
could generate all the shapefiles in one shot.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">giovanni<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="color:black"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">2013/11/5 Brent Wood <<a href="mailto:pcreso@pcreso.com" target="_blank">pcreso@pcreso.com</a>><o:p></o:p></span></p>
<div id="yiv5339078243yqt53375">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">I can open an XLS file OK, using vector dialogue, change file type to all, choose an xls file (created by Open Office) & I can open it & view the attribute table fine.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">What I'm unable to do is tell QGIS which columns to use for the lat/lon columns (each row represents a point). I can do this if I save the xls as a csv & open the delimited text file, but is there any way to do
this natively with the xls file? I don't want to store a QGIS csv version of every spreadsheet....<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Brent Wood<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="background:white"><span style="color:black"><br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="color:black"><br>
<br clear="all">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="background:white"><span style="color:black">-- <br>
Giovanni Allegri<br>
<a href="http://about.me/giovanniallegri" target="_blank">http://about.me/giovanniallegri</a><br>
blog: <a href="http://blog.spaziogis.it/" target="_blank">http://blog.spaziogis.it</a><br>
GEO+ geomatica in Italia <a href="http://bit.ly/GEOplus" target="_blank">http://bit.ly/GEOplus</a>
<o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>