Differences

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

--- python:exelprocess [2020/11/07 12:42] – [Function in Exel] admin
+++ python:exelprocess [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 122: / Line 122: @@
 parsexls(constantsfile)
 </code>
+==== Error Parse UTF-8 file ====
+<code>
+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)
+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 =====