[Qgis-user] How do I georeference an xls file opened in QGIS 2.0

[G. Allegri]

I understand your need and maybe it is worth a ticket, and maybe a
sponsorship :)

To keep a "live connection" with your spreadsheet you could create an OGR
virtual layer, using the OGR Virtual Format [1]. Yet an extra step but this
way your updates to the spreadsheet are automatically seen in your QGIS
project.

Giovanni

[1] http://www.gdal.org/ogr/drv_xls.html
Il 05/nov/2013 20:41 "Brent Wood" <pcreso at pcreso.com> ha scritto:

> Cheers...
>
> 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.
>
> I sort of figured that if a GIS tool can open an xls file this would be
> pretty basic functionality... perhaps optimistically :-)
>
> 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.
>
> 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.
>
> 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?
>
> Brent Wood
>
>   ------------------------------
>  *From:* G. Allegri <giohappy at gmail.com>
> *To:* Brent Wood <pcreso at pcreso.com>
> *Cc:* "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
> *Sent:* Wednesday, November 6, 2013 8:15 AM
> *Subject:* Re: [Qgis-user] How do I georeference an xls file opened in
> QGIS 2.0
>
> I don't know if there's a plugin for that.
> 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.
>
> giovanni
>
>
> 2013/11/5 Brent Wood <pcreso at pcreso.com>
>
>
> 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.
>
> 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....
>
> Brent Wood
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>
> --
> Giovanni Allegri
> http://about.me/giovanniallegri
> blog: http://blog.spaziogis.it
> GEO+ geomatica in Italia http://bit.ly/GEOplus
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131105/c5496243/attachment.html>