[QGIS-Developer] Loading many Excel-Files in QGIS with correct encoding

[Andreas Neumann]

Hi again,

I tried to set the layer encoding after the layer merging, but it fails 
;-(

And before the layer merging I cannot set the encoding in the model, 
because it only accepts a single layer as input, and not multiple 
layers.

So it seems that I will have to set the correct encoding right away from 
the beginning on - but I don't know how.

Thanks,

Andreas

On 2021-07-15 08:33, Andreas Neumann wrote:

> Hi,
> 
> I have a bunch of MS Excel .xls files in the old format (hundreds of 
> files), not the new .xlsx format.
> 
> The content of the .xls files seems to be UTF-8 encoded, but QGIS loads 
> them with some LATIN-x encoding - all of the non-ASCII-characters look 
> garbled.
> 
> I want to process these files with Processing and merge them into one 
> file.
> 
> Is there any way how I can load these files with the correct UTF-8 
> encoding? I know, there is an algorithm to set the correct encoding of 
> a layer in processing, but unfortunately this doesn't work with 
> multi-layer input, only with single layer input.
> 
> Is there some OGR trick (environment variable or opening option) to 
> load the files with correct encoding?
> 
> Thanks if you have any hint,
> 
> Andreas
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20210715/d4c81d9e/attachment.html>