Well, you can do this with DBF files, which Excel can open and save (part of a SHP). Or are you trying to save the spatial aspects in a tabular manner?
Bobb From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Brent Wood Sent: Tuesday, November 05, 2013 1:41 PM To: G. Allegri Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] How do I georeference an xls file opened in QGIS 2.0 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<mailto:gioha...@gmail.com>> To: Brent Wood <pcr...@pcreso.com<mailto:pcr...@pcreso.com>> Cc: "qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>" <qgis-user@lists.osgeo.org<mailto: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<mailto: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<mailto:Qgis-user@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giovanni Allegri http://about.me/giovanniallegri blog: http://blog.spaziogis.it<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
