Hi Micha,
thank you.
And where in this theoretical situation exactly do you use drag and drop
of spreadsheets to the canvas in this process?
Bernd
Am 13.03.22 um 09:56 schrieb 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@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
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
