excel - Python抛出 "' utf 8' codec can' t解码字节0xd0在位置0“错误

Question

我正在尝试加载当前现有的工作表并导入如下所示的文本文件(逗号分隔值)屏幕截图，

Excel 工作表:

文本文件:

我正在使用如下所示的代码:

# importing necessary modules for performing the required operation
    import glob
    import csv
    from openpyxl import load_workbook
    import xlwt

    #read the text file(s) using the CSV modules and read the dilimiters and quoutechar
    for filename in glob.glob("E:\Scripting_Test\Phase1\*.txt"):
        spamReader = csv.reader((open(filename, 'rb')), delimiter=',')


        #read the excel file and using xlwt modules and set the active sheet
        wb = load_workbook(filename=r"E:\Scripting_Test\SeqTem\Seq0001.xls")
        ws = wb.worksheets(0)


        #write the data that is in text file to excel file
        for rowx, row in enumerate(spamReader):
            for colx, value in enumerate(row):
                ws.write(rowx, colx, value)

        wb.save()

我收到以下错误消息:

UnicodeDecodeError: 'utf8' codec can't decode byte 0xd0 in position 0: invalid continuation byte

还有一个问题:如何让python导入Excel工作表中从A3列开始的文本数据？

Answer 1

Unicode 编码让我很困惑，但是你不能通过说以下内容强制该值忽略无效字节:

value = unicode(value, errors='ignore')

这里有一个很好的答案，可以让您进一步阅读有关 unicode 的内容:unicode().decode('utf-8', 'ignore') raising UnicodeEncodeError