Hi,
Seems like when I load the same file from the newer .xlsx format then
the encoding is fine.
Now I need to find a way how to batch-convert all of the many .xls to
.xlsx files automatically.
Still I find it disturbing that QGIS doesn't allow me to load the older
.xls files with correct encoding without manual intervention.
Andreas
On 2021-07-15 08:56, Andreas Neumann wrote:
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
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________
QGIS-Developer mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________
QGIS-Developer mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
