<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Micha,</p>
<p><br>
</p>
<p>can you elobrate a bit more on these situations where the data
has no column header, cause I don't know them.</p>
<p><br>
</p>
<p>Bernd<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 13.03.22 um 09:35 schrieb Micha
Silver:<br>
</div>
<blockquote type="cite"
cite="mid:b177ebb3-19a4-9f47-0175-e50e5fd171fb@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style id="bidiui-paragraph-margins" type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; }</style>
<p><br>
</p>
<div class="moz-cite-prefix">On 13/03/2022 10:22, Bernd
Vogelgesang via Qgis-user wrote:<br>
</div>
<blockquote type="cite"
cite="mid:0659f8da-2546-18bf-d695-26df78430e9e@gmx.de">
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<p>Hi Andrea,</p>
<p>thanx for clarifying.</p>
<p>imho this is not a "wise" design decision. Maybe I am too
less a pro, but i can't think of any situation when someone
seriously working with table data does NOT want to have a
column header. What would be the advantage of that?</p>
</blockquote>
<p><br>
</p>
<p>There are situations where the data table contains only data:
no column headers. <br>
</p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:0659f8da-2546-18bf-d695-26df78430e9e@gmx.de">
<p>Ok, if this is a GDAL-design decision, then at least QGIS
should have default settings in the environment preventing
this.</p>
<p>An ordinary user will never ever expect this behaviour nor
find this setting by himself.</p>
<p>Cheers,</p>
<p>Bernd<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 13.03.22 um 08:55 schrieb Andrea
Giudiceandrea:<br>
</div>
<blockquote type="cite"
cite="mid:290d82a9-d20b-c7b3-d0ea-47a7820abce6@libero.it">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<blockquote type="cite"><b style="color: rgb(0, 0, 0);
font-family: "Times New Roman"; font-size:
medium; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; letter-spacing: normal;
orphans: 2; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;">Bernd
Vogelgesang</b><span style="color: rgb(0, 0, 0);
font-family: "Times New Roman"; font-size:
medium; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255,
255, 255); text-decoration-thickness: initial;
text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"><span></span></span><br
style="color: rgb(0, 0, 0); font-family: "Times New
Roman"; font-size: medium; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial;">
<i style="color: rgb(0, 0, 0); font-family: "Times New
Roman"; font-size: medium; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial;">Sat Mar 12 14:13:04 PST
2022</i><span style="color: rgb(0, 0, 0); font-family:
"Times New Roman"; font-size: medium;
font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255,
255, 255); text-decoration-thickness: initial;
text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;"></span>
<hr style="color: rgb(0, 0, 0); font-family: "Times New
Roman"; font-size: medium; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; text-decoration-thickness:
initial; text-decoration-style: initial;
text-decoration-color: initial;">
<pre style="white-space: pre-wrap; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">So: All-string tables will not be imported correctly. Always e.g. add an
id-field with number
</pre>
</blockquote>
<br>
Hi Bernd,<br>
this is by design: <a class="moz-txt-link-freetext"
href="https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598"
moz-do-not-send="true">https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598</a><br>
<br>
Am 12.03.22 um 23:04 schrieb Jonas Küpper:<i> </i>
<blockquote type="cite">
<pre style="white-space: pre-wrap; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">><i> what should have fixed it as well would be to pass OGR_XLSX_HEADERS =
</i>><i> FORCE to the provider while loading xlsx-files but a i couldn't find a
</i>><i> way how to do that. (see <a href="https://gdal.org/drivers/vector/xlsx.html" class="moz-txt-link-freetext" moz-do-not-send="true">https://gdal.org/drivers/vector/xlsx.html</a>)
</i></pre>
</blockquote>
<br>
Hi Jonas,<br>
you can set a GDAL/OGR configuration option, like
OGR_XLSX_HEADERS, via the "Settings" -> "Options" ->
"System" -> "Environment" setting panel in QGIS.<br>
<br>
Regards.<br>
<br>
Andrea Giudiceandrea<br>
</blockquote>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:Qgis-user@lists.osgeo.org" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" moz-do-not-send="true">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" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</blockquote>
</body>
</html>