[Qgis-user] Importing spreadsheet: Strange behaviour

[Bernd Vogelgesang]

Hi Micha,


can you elobrate a bit more on these situations where the data has no
column header, cause I don't know them.


Bernd


Am 13.03.22 um 09:35 schrieb Micha Silver:
>
>
> 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
>> Qgis-user at lists.osgeo.org
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220313/33670a49/attachment-0001.html>