python读excel乱码_Python读写excel练习_去除excel中乱码行，并添加列

importxlrd,xlwt

EXCEL_NAME= 'app_student.xls'

def delete_messy_code(excel_name): #删除乱码

book =xlrd.open_workbook(excel_name)

sheet=book.sheet_by_index(0)

data=[]for i inrange(sheet.nrows):if '?' in str(sheet.row_values(i)):#仅将没有乱码的数据加入data[]

continue

else:

data.append(sheet.row_values(i))returndatadef update_col(data): #增加列，并填入是否毕业

for d indata:if d[5] == 'grade':

d.append('是否毕业')elif d[5] == '天蝎座':

d.append('毕业')else:

d.append('未毕业')returndatadef wt_excel(excel_name): #将处理后的结果写入Excel

rb =xlwt.Workbook()

rbs=rb.add_sheet('sheet1')

data=delete_messy_code(excel_name)

row=0for field inupdate_col(data):for col, f inenumerate(field):

rbs.write(row,col,f)

row+= 1rb.save(excel_name)

wt_excel(EXCEL_NAME)