问题描述：

代码:

importsys

reload(sys)

sys.setdefaultencoding('utf-8')

importjieba

importjieba.analyse

importopenpyxl

if__name__ =="__main__":

    wbk = openpyxl.Workbook(encoding='ascii')

    sheet = wbk.add_sheet("wordCount")  

word_lst = []

    key_list = []

forlineinopen('/home/frida/1.txt'):  

item = line.strip('\n\r').split('\t')  

# print item

tags = jieba.analyse.extract_tags(item[0])  

fortintags:

            word_lst.append(t)

    word_dict = {}

withopen("/home/frida/wordCount.txt",'w')aswf2:  

foriteminword_lst:

ifitemnot inword_dict:  

word_dict[item] =1

else:

                word_dict[item] +=1

orderList =list(word_dict.values())

        orderList.sort(reverse=True)

# print orderList

foriinrange(len(orderList)):

forkeyinword_dict:

ifword_dict[key] == orderList:

                    wf2.write(key +' '+str(word_dict[key]) +'\n')  

key_list.append(key)

                    word_dict[key] =0

foriinrange(len(key_list)):

        sheet.write(i,1,label=orderList)

        sheet.write(i,0,label=key_list)

    wbk.save('wordCount_xls')  

运行结果显示 line 16, in <module>    wbk = openpyxl.Workbook(encoding='ascii')TypeError: __init__() got an unexpected keyword argument 'encoding'

解决方法;

这是对workbook的描述，没有encoding参数

Init signature: Workbook(write_only=False, iso_dates=False)

Docstring:      Workbook is the container for all other parts of the document.

File:           c:\programdata\anaconda3\lib\site-packages\openpyxl\workbook\workbook.py

Type:           type