<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>Seems like when I load the same file from the newer .xlsx format then the encoding is fine.</p>
<p>Now I need to find a way how to batch-convert all of the many .xls to .xlsx files automatically.</p>
<p>Still I find it disturbing that QGIS doesn't allow me to load the older .xls files with correct encoding without manual intervention.</p>
<p>Andreas</p>
<p id="reply-intro">On 2021-07-15 08:56, Andreas Neumann wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>Hi again,</p>
<p>I tried to set the layer encoding after the layer merging, but it fails ;-(</p>
<p>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.</p>
<p>So it seems that I will have to set the correct encoding right away from the beginning on - but I don't know how.</p>
<p>Thanks,</p>
<p>Andreas</p>
<p id="v1reply-intro">On 2021-07-15 08:33, Andreas Neumann wrote:</p>
<blockquote style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0;">
<div id="v1replybody1">
<div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>Hi,</p>
<p>I have a bunch of MS Excel .xls files in the old format (hundreds of files), not the new .xlsx format.</p>
<p>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.</p>
<p>I want to process these files with Processing and merge them into one file.</p>
<p>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.</p>
<p>Is there some OGR trick (environment variable or opening option) to load the files with correct encoding?</p>
<p>Thanks if you have any hint,</p>
<p>Andreas</p>
</div>
</div>
<br />
<div class="v1pre" style="margin: 0; padding: 0; font-family: monospace;">_______________________________________________<br />QGIS-Developer mailing list<br /><a href="mailto:QGIS-Developer@lists.osgeo.org" rel="noreferrer">QGIS-Developer@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
<p><br /></p>
</div>
</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br />QGIS-Developer mailing list<br /><a href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
<p><br /></p>
</body></html>