[Qgis-user] Equations cells imported to QGIS

[Ludwig Kniprath]

Hi Simon,

Excel tables don't need to be saved as delimited text, they can be 
imported direct to QGis, f.e. with drag&drop.


Calculated contents in the spreadsheets are no problem, below my test 
with a simple table:

(note: screenshot from LibreOffice, I hope there is no difference using 
excel)

'Show Formula' as view-mode:


Normal view mode:


Imported to QGis: all cells with the last calculated and saved values


The imported table can than be joined to any existing vector-layer or 
converted to point-layer f.e. via Processing Toolbox > Vector creation > 
Create points layer from table.


Notes:

- You can even edit and save the imported table in QGis, but that will 
convert all formulas to simple alpha-numeric contents.

- Formulas are not refreshed automatically when imported to QGis, so the 
above field with the formula '=NOW()' (current time) will always show 
the last calculated value in QGis, not the actual time.


hth

Ludwig


Am 16.06.23 um 17:53 schrieb Simon via QGIS-User:
> Hi all,
>
> Excel spreadsheets can be imported into QGIS when they're formatted as 
> Delimited text layers, but is it possible to import a spreadsheet with 
> various cells containing different equations and then display them on 
> a map?
>
> Thanks,
>
> Simon
>
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230616/68b3698b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oc4UMKpcJZ7FxDXo.png
Type: image/png
Size: 19281 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230616/68b3698b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: WlwORYi8tJH7VLnC.png
Type: image/png
Size: 15862 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230616/68b3698b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vsnu4aN0V7boclhH.png
Type: image/png
Size: 64915 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230616/68b3698b/attachment-0005.png>