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 02:45] – [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>
 +xlsfile = xlrd.open_workbook(filename,verbosity=3)
 +</code>output:<code>
 +BOF: op=0x0809 vers=0x0600 stream=0x0005 buildid=14420 buildyr=1997 -> BIFF80
 +CODEPAGE: codepage 1200 -> encoding 'utf_16_le'
 +DATEMODE: datemode 0
 +</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.1618022735.txt.gz · Last modified: (external edit)