Sorry, the right link: http://www.gdal.org/ogr/drv_vrt.html Il 05/nov/2013 21:34 "G. Allegri" <gioha...@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" <pcr...@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 <gioha...@gmail.com> >> *To:* Brent Wood <pcr...@pcreso.com> >> *Cc:* "qgis-user@lists.osgeo.org" <qgis-user@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 <pcr...@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@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 >> >> >>
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user