[Qgis-user] Importing spreadsheet: Strange behaviour

[Bernd Vogelgesang]

Hi Andrea,

thanx for clarifying.

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?

Ok, if this is a GDAL-design decision, then at least QGIS should have
default settings in the environment preventing this.

An ordinary user will never ever expect this behaviour nor find this
setting by himself.

Cheers,

Bernd


Am 13.03.22 um 08:55 schrieb Andrea Giudiceandrea:
>> *Bernd Vogelgesang*
>> /Sat Mar 12 14:13:04 PST 2022/
>> ------------------------------------------------------------------------
>> So: All-string tables will not be imported correctly. Always e.g. add an
>> id-field with number
>
> Hi Bernd,
> this is by design:
> https://github.com/OSGeo/gdal/blob/1c5bc766513c4407f702bd8cd8bfa958ed61cfea/ogr/ogrsf_frmts/xlsx/ogrxlsxdatasource.cpp#L597-L598
>
> Am 12.03.22 um 23:04 schrieb Jonas Küpper://
>> >/what should have fixed it as well would be to pass OGR_XLSX_HEADERS = />/FORCE to the provider while loading xlsx-files but a i couldn't find a />/way how to do that. (see https://gdal.org/drivers/vector/xlsx.html) /
>
> Hi Jonas,
> you can set a GDAL/OGR configuration option, like OGR_XLSX_HEADERS,
> via the "Settings" -> "Options" -> "System" -> "Environment" setting
> panel in QGIS.
>
> Regards.
>
> Andrea Giudiceandrea
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220313/73cd8127/attachment.html>