<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Simon, <br>
</p>
<p>Excel tables don't need to be saved as delimited text, they can
be imported direct to QGis, f.e. with drag&drop.</p>
<p><br>
</p>
<p>Calculated contents in the spreadsheets are no problem, below my
test with a simple table:</p>
<p>(note: screenshot from LibreOffice, I hope there is no difference
using excel)</p>
<p>'Show Formula' as view-mode:</p>
<p><img src="cid:part1.zSjNnG0e.J0MGG1ga@kni-online.de" alt=""></p>
<p><br>
</p>
<p>Normal view mode:</p>
<p><img src="cid:part2.gDIdnokj.wxRkVEyS@kni-online.de" alt=""></p>
<p><br>
</p>
<p>Imported to QGis: all cells with the last calculated and saved
values<br>
</p>
<p><img src="cid:part3.gv0XkDvO.uAZmwgdQ@kni-online.de" alt=""></p>
<p><br>
</p>
<p>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.</p>
<p><br>
</p>
<p>Notes: <br>
</p>
<p>- You can even edit and save the imported table in QGis, but that
will convert all formulas to simple alpha-numeric contents.</p>
<p>- 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.</p>
<p><br>
</p>
<p>hth</p>
<p>Ludwig<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 16.06.23 um 17:53 schrieb Simon via
QGIS-User:<br>
</div>
<blockquote type="cite"
cite="mid:YT1PR01MB90501AD756482199C85C808CC358A@YT1PR01MB9050.CANPRD01.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Hi all,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">Excel spreadsheets can
be imported into QGIS when they're formatted as Delimited text
layers, but is it possible to </span><span style="font-family:
Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color:
rgb(0, 0, 0);">import a spreadsheet with various cells
containing different equations and then display them on a map?</span><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">Thanks, </span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">Simon</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<span style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>