Excel import fails with files exported from Intellij DataGrip

[rpx99]

Did an export of a TEST table into a .xlsx file using the Excel extractor included in Intellij DataGrip (latest 2024.2.3 Ultimate) with its included export funtionality.

When I try to import the exported file into duckdb I get the error message presented:

[2024-10-07 15:13:57] Connected
test.main> INSTALL spatial
[2024-10-07 15:13:57] completed in 10 ms
test.main> LOAD spatial
[2024-10-07 15:13:57] completed in 219 ms
test.main> CREATE OR REPLACE TABLE TESTTBL AS SELECT * FROM st_read('c:/temp/TEST.xlsx', layer = 'Result 1')
[2024-10-07 15:13:57] IO Error: GDAL Error (1): Invalid row: 0

The file export results in a quite small .xlsx.

Storing the exported file again with EXCEL (in my case version 2016) makes the file larger as additional information seems to get included, but this version can be succesfully imported into duckdb.

test.main> INSTALL spatial
[2024-10-07 15:14:35] completed in 3 ms
test.main> LOAD spatial
[2024-10-07 15:14:35] completed in 3 ms
test.main> CREATE OR REPLACE TABLE TESTTBL AS SELECT * FROM st_read('c:/temp/TEST2.xlsx', layer = 'Result 1')
[2024-10-07 15:14:35] completed in 51 ms

Don't know if it's a bug but at least good to know...

Additionally it seems a lock on the import file seems to be kept (which does not look correct):

[2024-10-07 15:13:57] Connected
test.main> INSTALL spatial
[2024-10-07 15:13:57] completed in 10 ms
test.main> LOAD spatial
[2024-10-07 15:13:57] completed in 219 ms
test.main> CREATE OR REPLACE TABLE TESTTBL AS SELECT * FROM st_read('c:/temp/TEST.xlsx', layer = 'Result 1')
[2024-10-07 15:13:57] IO Error: GDAL Error (1): Invalid row: 0
test.main> INSTALL spatial
[2024-10-07 15:14:19] completed in 3 ms
test.main> LOAD spatial
[2024-10-07 15:14:19] completed in 3 ms
test.main> CREATE OR REPLACE TABLE TESTTBL AS SELECT * FROM st_read('c:/temp/TEST.xlsx', layer = 'Result 1')
[2024-10-07 15:14:19] IO Error: GDAL Error (1): GDALOpen() called on c:/temp/TEST.xlsx recursively

Here the files:

TEST.xlsx
TEST2.xlsx

[rouault]

will be fixed in GDAL 3.10 per OSGeo/gdal#11000