<html style="direction: ltr;">
<head>
<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>
</head>
<body bidimailui-charset-is-forced="true" style="direction: ltr;">
<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" 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>
<pre class="moz-signature" cols="72">--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918</pre>
</body>
</html>