Differences

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

--- python:exelprocess [2021/04/10 02:40] – [Parse xls file] admin
+++ python:exelprocess [2022/03/19 13:31] – [Error Parse UTF-8 file] admin
@@ Line 124: / Line 124: @@
 ==== Error Parse UTF-8 file ====
 <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>
+</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 =====