my notes

User Tools

Site Tools

Trace:
python:exelprocess

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
python:exelprocess [2021/04/10 05:25] – [Error Parse UTF-8 file] adminpython:exelprocess [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 124: Line 124:
 ==== Error Parse UTF-8 file ==== ==== Error Parse UTF-8 file ====
 <code> <code>
-UnicodeDecodeError: 'utf16' codec can't decode bytes in position+UnicodeDecodeError: 'utf16' codec can't decode bytes in position 3438-3439: unexpected end of data
 </code> => Check exel format in encoding(not utf-8)(May be exel file was not stored as encoding utf-8, It can be saved as utf16 default encoding)  </code> => Check exel format in encoding(not utf-8)(May be exel file was not stored as encoding utf-8, It can be saved as utf16 default encoding) 
 You can debug for information:<code python> You can debug for information:<code python>
Line 132: Line 132:
 CODEPAGE: codepage 1200 -> encoding 'utf_16_le' CODEPAGE: codepage 1200 -> encoding 'utf_16_le'
 DATEMODE: datemode 0 DATEMODE: datemode 0
-</code> => encoding: **'utf_16_le'**+</code> => default encoding: **'utf_16_le'** 
 + 
 +**Fix**: Lỗi do file exel, mở lại file exel và lưu lại sẽ hết lỗi
 ===== Using xlwt ===== ===== Using xlwt =====
python/exelprocess.1618032324.txt.gz · Last modified: 2022/10/29 16:15 (external edit)