I've done something like this in the distant past. Put data into a postgis database. Link excel to the database.
That's the basics, there are a few details I don't have time to dig out at the moment. If you haven't figured it out in a couple of weeks when I'm back at my desk let me know and I'll see what I can put together. Matt On 28 Dec 2015 10:36 pm, "Siki Zoltan" <s...@agt.bme.hu> wrote: > Dear Eva, > > AFAIK there is no direct solution to edit ods/xls/xlsx files from QGIS. > There are two possible scenarios: > 1. Edit your speadseet data in Libre|Open|MS office and open it in QGIS > and join it to your spatial data. If your spreadsheet is open in both QGIS > and Excel it can cause trouble. > > 2. Open you spreadsheet in QGIS and save as a QGIS editable format (e.g. > dbf, sqlite) and edit these data. If you need again these data in a > spreadsheet convert it back (probably through csv format). > > Hope it helps you, > > Zoltan > > On Mon, 28 Dec 2015, Eva Mosquera wrote: > > Hello everybody!I need to use the data I have in my shpfile in qgis in >> excel. I need an excel spreadsheet that is able by itself to keep updated >> with the data changes in qgis. And I don't know how to do this. >> I'm trying to import the database (dbf) in excel but I have problems with >> the type and characteristics... >> Thank you very much >> > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user