I have a project in Qgis that gets its data from a locally stored excel file (linked). Is there a way to automatically update the linked data? What is happening now is that when I change some rows in the excel file, I have to go back to the project "delete" and "classify" the selected data. I would like to see this automated. I have very few (none) experience with Qgis.
-
Is it an excel file or a csv? If the layer is classified using the column attribute it should stay classified even if the rows change. If you right click on the layer you can see the attribute table and that may help "visualize" what is happening. From VIEW -> Panels -> Layer Styling you can select the column you want to Categorize with. Look Here -> ibb.co/tDJrv9V– Cary HFeb 27, 2019 at 19:52
-
1It would probably be helpful if you could give us a little more information about what you are doing. For example, plotting points in an Excel file on background mapping. Does the Excel file contain xy coordinates?– nhoptonFeb 27, 2019 at 20:09
-
1I got CSV file working with the 'watch file' gis.stackexchange.com/questions/148812/…– Mapperz ♦Feb 27, 2019 at 23:05
-
@nhopton: I got a layer that is linked with a shape file (Qgis ID - Coordinates) next I have another layer that is linked with the excel file (Qgis ID - Name). Through the Qgis ID I'm able to link Coordinate with Name.– BCallBEFeb 28, 2019 at 7:08
-
@Cary H: I opened your link and this is exactly what I'm seeing in my layer that contains the shape file. If I change values in the column of the locally stored excel file, I automatically see changes in the layer in qgis that's connected to it, but the layer containing the shapefile doesn't refresh its data. In layer containing shapefile I go to: properties-symbology-delete all-classify– BCallBEFeb 28, 2019 at 8:14
|
Show 1 more comment