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