[Qgis-user] Importing spreadsheet: Strange behaviour

[Micha Silver]

On 13/03/2022 10:37, Bernd Vogelgesang wrote:
>
> Hi Micha,
>
>
> can you elobrate a bit more on these situations where the data has no 
> column header, cause I don't know them.
>
>

Well, just a few theoretical examples:

I might have several tables of data from some sensor (i.e. rainfall, 
temperature) with dates, long/lat and column headers. Merging all the 
tables would cause the column headers to get repeated for each table. I 
usually just remove *all* column headers, then import, and point to the 
correct columns for long/lat.


When I extract values from a multiband raster at point locations (for 
some ML model) I get just columns of values; the actual column names are 
not important.


Hope that clarifies.


> 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

-- 
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918