How to set OGR_XLSX_HEADERS

[imadhajjchahine]

Hi,

In duckdb CLI I have installed and load the spatial extension, and I am trying to
SET OGR_XLSX_HEADERS='FORCE';
Error: Catalog Error: unrecognized configuration parameter "OGR_XLSX_HEADERS"

Any guide on how to set this flag and how to set on per query basis.

Thanks

[Maxxen]

EDIT:
Implemented in #114

Hi!

It is not possible to set this on a per-query basis as of now. You should be able to set it as a environment variable so GDAL can pick it up. https://gdal.org/user/configoptions.html#configoptions

Im currently on vacation, but In the future ill look into making it possible to set these sorts of options directly from duckdb.

[davidjbrennan]

It would be so useful if these options could be set as "open options" rather than the current "configuration options" so that every query didn't have to use the same options.

Hope you are able to look in to this and make it possible.

[Maxxen]

Thanks for the feedback, I've implemented a fix for this in #114

[Maxxen]

Implemented in #114