Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-21 Thread Andre Joost
Am 21.01.2013 09:19, schrieb Pietro Rossin: Alister Hood wrote I think the solution is already coming: with GDAL 1.10 there should be support for .ods... Super! I hope that Gdal 1.10 will be soon integrated into osgeo4w.. It would be a good idea to update the gdal-dev package in Osgeo4w. In

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-21 Thread Pietro Rossin
Alister Hood wrote > I think the solution is already coming: with GDAL 1.10 there should be > support for .ods... Super! I hope that Gdal 1.10 will be soon integrated into osgeo4w.. pietro -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Use-excel-spreadsheets-for-join-to-v

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Andreas Neumann
spreadsheets for join to vector data Message-ID: <1358412618272-5028049.p...@n6.nabble.com> Content-Type: text/plain; charset=us-ascii @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

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Alister Hood
> Date: Thu, 17 Jan 2013 00:50:18 -0800 (PST) > From: Pietro Rossin > To: qgis-user@lists.osgeo.org > Subject: Re: [Qgis-user] Use excel spreadsheets for join to vector > data > Message-ID: <1358412618272-5028049.p...@n6.nabble.com> > Content-Type: text/plain; c

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Micha Silver
On 17/01/2013 10:50, Pietro Rossin wrote: @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 sq

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Johan Nilsson
I have problem to load an xls-file with gett this message: -- *An error has occured while executing Python code:* *Traceback (most recent call last): File "/home/a/.qgis//python/plugins/xytools/xytools.py

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Paolo Cavallini
Il 17/01/2013 09:50, Pietro Rossin ha scritto: > 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? oh, now I see. perhaps these packages would help? python-openpyxl python-xlrd python-xlwt All the be

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-17 Thread Pietro Rossin
@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

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-16 Thread Paolo Cavallini
Il 16/01/2013 20:40, Pietro Rossin ha scritto: > I realized that with python-xlrd and python-xlwt installed with osgeo4w on > windows xp I can load excel data in qgis as is for csv data (add vector). > The sheet1 is loaded and first line is usually used as field name. > This is what happens in Win

Re: [Qgis-user] Use excel spreadsheets for join to vector data

2013-01-16 Thread Micha Silver
Using spatialite you can load an xls spreadsheet, then do SQL joins, or copy data over to a spatial layer. Regards, Micha On 16/01/2013 21:40, Pietro Rossin wrote: Hello all I realized that with python-xlrd and python-xlwt installed wi

[Qgis-user] Use excel spreadsheets for join to vector data

2013-01-16 Thread Pietro Rossin
Hello all I realized that with python-xlrd and python-xlwt installed with osgeo4w on windows xp I can load excel data in qgis as is for csv data (add vector). The sheet1 is loaded and first line is usually used as field name. This is what happens in Window$, I tried to install these two packages in