[Qgis-user] editing a layer in excel

Christine geo.guide at web.de
Wed Dec 16 23:58:50 PST 2020


dear Marin,

yes, this workflow should work. 

But you can also edit the attribute table directly in QGIS: 
select the layer to edit in the Layers Tree, right click and choose: "Toggle
Editing" (~ open editing)  and then with right click again: "Open Attribut
Table". The Attribute Table should be then displayed ready to edit, rather
similar like in Excel. 
Having completed editing, save the edits with the save button and then
"Toggle Editing"  to close  the editing session again. 

There is a toggling mechanism to prevent users from unvoluntary changes of
their layers.

Regards, Christine


Marin Mirosevic wrote
> If workflow could be confirmed that this is ok the way Columns can be
> updated/Joined?
> 
>   1.  Export as excel from a Layer (from Qgis)
>   2.  Edit Excel file (edists are backpropagated to Qgis table)
>   3.  Right click on Polygon/Point  (holding attributes) - Properties
> -Joins (select excel table which lies as table in Qgis )-select Join and
> Target field(which have to be the same)- select Joined fields(to bring in
> changed columns in Excel itself)
>   4.  Column(s) added
> 
> Also could Parameters/Columns - be just updated with new values (maybe
> better then join as new parameter/column)? IF yes how ( didn't found an
> option)





--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html


More information about the Qgis-user mailing list