|
On 13/03/2022 10:22, Bernd Vogelgesang
via Qgis-user wrote:
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?
There are situations where the data table contains only data: no
column headers.
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
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918
|
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
