<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset" text="#660000"
bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 17/01/2013 10:50, Pietro Rossin
wrote:<br>
</div>
<blockquote cite="mid:1358412618272-5028049.post@n6.nabble.com"
type="cite">
<pre wrap="">@Micha
Thankyou for your suggestion
Ok I can load xls files to sqlite and then make any sql join on that, but
it's not user friendly and I have to make two steps, one is the creation of
xls and the other the import into a sqlite db..
If you don't want to mess with closed format it would be nice to deal with
.ods format.</pre>
</blockquote>
Spatialite uses the freexl library, which can read only Excel 2003
*.xls files. So you do have to save from ods format to xls. Other
than that, it's pretty straightforward once you understand the SQL
join options.<br>
<br>
<blockquote cite="mid:1358412618272-5028049.post@n6.nabble.com"
type="cite">
<pre wrap="">
You may say I'm lazy, ok, that's right, I am indeed ;-)
But I think that for any beginner this solution will be super appreciated.
@Paolo
Hi
xytools plugin ask for x and y column when loading a spreadsheet file.
If the spreadsheet doesn't have these fields It won't be loaded, isn't it?
Thankyou all!
Pietro
--
View this message in context: <a class="moz-txt-link-freetext" href="http://osgeo-org.1560.n6.nabble.com/Use-excel-spreadsheets-for-join-to-vector-data-tp5027957p5028049.html">http://osgeo-org.1560.n6.nabble.com/Use-excel-spreadsheets-for-join-to-vector-data-tp5027957p5028049.html</a>
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consulting
052-3665918
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a>
</pre>
</body>
</html>