This might be the plugin you are talking about: https://plugins.qgis.org/plugins/SpreadsheetLayers/
A dom, 10/07/2016, 13:16, Richard Duivenvoorde <[email protected]> escreveu: > > @paolo: which plugin are you thinking of? > Because for exampe xytools can open odt and excel, but via python, while > the idea here is to be able to load whatever (table) format ogr is able > to load. And not only given and x,y field but also a column containing > wkt polygons (as the csv-provider does that already)... > This would for example also work for a dbf containg x,y values > > @mattias: mm, if I load a strict csv table (be it csv or excel), > containing an x and y column, according to this blogpost: > http://www.opengis.ch/2015/12/10/geometry-generator-symbology/ > I should be able to select a geometry generator in styles.. but with a > table the styles is ... empty :-( > > Tried to make a geometry using vectorcalc, but it will not 'morph' the > layer from a table (icon) in a geometry/point icon and the points (I > tried: make_point) > > I am aware that this is probably readonly, but that is ok I think. > > Regards, > > Richard > > On 09-07-16 11:44, Matthias Kuhn wrote: > > Hi, > > > > I think there are already 2 possibilities to show x,y /wkt or other > > geometries for any kind of layers > > > > * Geometry generators > > > > * Virtual layers (no expert, but I guess that's possible) > > > > So at least read-only this should be straightforward, read-write maybe > > with virtual layers (?). > > > > Matthias > > > > On 07/09/2016 11:34 AM, Raymond Nijssen wrote: > >> Great idea! ;) > >> > >> Question is where to implement it in the GUI. It overlaps the > >> functionality in the delimited text reader. Like pointing to the x and y > >> columns or choosing a column containing wkt. > >> > >> Maybe it could be a 2 steps process? Step 1 is importing any table and > >> step 2 is creating a spatial layer from it. But we would loose the quick > >> "Add delimited text layer" functionality. > >> > >> Any ideas? > >> > >> @Paolo, which plugin can do this? XyTools? > >> > >> Regards, > >> Raymond > >> > >> > >> > >> > >> On 09-07-16 11:14, Paolo Cavallini wrote: > >>> Agreed. There is a plugin doing this, but of course having it as a > >>> standard function is desirable. > >>> Thanks for raising this. > >>> > >>> Il 9 luglio 2016 12:00:38 EEST, Richard Duivenvoorde > >>> <[email protected]> ha scritto: > >>> > >>> Hi Devs, > >>> > >>> Raymond Nijssen had an (I think) intriguing idea: > >>> > >>> QGIS can open different types of table-data: dbf, excel etc etc > >>> > >>> But if the excel contains an x,y,wkt column, you have to save it to > >>> csv/tsv first, to be able to use the delimited-text-provider to > open it > >>> as a layer. > >>> > >>> His idea: can't we use the delimited-text-provider for all tables > that > >>> are open in QGIS immediately? > >>> > >>> Had a look into the code > >>> > >>> > https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.cpp#L583 > >>> > >>> which 'just' looks like a QTextStream: > >>> > >>> > https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.h#L352 > >>> > >>> And > >>> according to this: > >>> > https://forum.qt.io/topic/63310/how-to-save-a-treeview-as-csv-file-in-qt > >>> > >>> It is easy to create a textstream from QModel (in which we have > the data > >>> I think???)... > >>> > >>> So Question: > >>> - (to devs): would this indeed be doable/easy? > >>> - (to UI's): should the Delimited Text File dialog be updated then > (or > >>> only with a 'open excisting table button'? > >>> - should we rename the provider to 'table' provider. > >>> > >>> Comments/Opinions? > >>> > >>> Regards, > >>> > >>> Richard Duivenvoorde > >>> > ------------------------------------------------------------------------ > >>> > >>> Qgis-developer mailing list > >>> [email protected] > >>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > >>> Unsubscribe: > http://lists.osgeo.org/mailman/listinfo/qgis-developer > >>> > >>> > >>> -- > >>> Paolo Cavallini > >>> www.faunalia.eu <http://www.faunalia.eu> > >>> > >>> > >>> _______________________________________________ > >>> Qgis-developer mailing list > >>> [email protected] > >>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > >>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > >>> > >> _______________________________________________ > >> Qgis-developer mailing list > >> [email protected] > >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > > > > -- > > Matthias Kuhn > > OPENGIS.ch - https://www.opengis.ch > > Spatial • (Q)GIS • PostGIS • Open Source > > > > > > > > _______________________________________________ > > Qgis-developer mailing list > > [email protected] > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > > > > _______________________________________________ > Qgis-developer mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Alexandre Neto --------------------- @AlexNetoGeo http://sigsemgrilhetas.wordpress.com http://gisunchained.wordpress.com
_______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
