[gdal-dev] Errors when reading large xlsx files

[Andrew C Aitchison]

On Tue, 29 Mar 2022, Dirk Vanden Boer wrote:

> Scanning through the file, it turns out 2 lines actually have a value in
> the eight column, that's why the column is present, it doesn't have a
> header for that column however.
>
> So I have 2 questions:
> - does the error impact the returned data?
> - Is there a way to suppress this error without disabling the gdal log
> handling. My logs are flooded with these messages, modifying the xlsx files
> is not an option because there are many and they are supplied by clients
> and regularly updated.

IIRC there are ways to batch-edit .xslx files.

Can you pre-process the xlsx file to add a header to that column -
" " may be sufficient ?

-- 
Andrew C. Aitchison					Kendal, UK
 			andrew at aitchison.me.uk