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

[G. Allegri]

Sorry, the right link: http://www.gdal.org/ogr/drv_vrt.html
Il 05/nov/2013 21:34 "G. Allegri" <giohappy at gmail.com> ha scritto:

> 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/6f854af5/attachment.html>