On Thu, 15 Jul 2021 at 17:12, Andreas Neumann <[email protected]> wrote: > > 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.
Isn't this limitation ultimately that GDAL isn't reading the encoding correctly? (Or perhaps it's a limitation in the underlying freexl library...) Nyall > > 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 _______________________________________________ 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
