<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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>
<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>
</body>
</html>