python讀寫excel實(shí)例-python讀寫Excel表格的實(shí)例代碼（簡單實(shí)用）

python讀寫excel實(shí)例_python讀寫Excel表格的實(shí)例代碼（簡單實(shí)?）安裝兩個庫：pipinstallxlrd、pipinstallxlwt1.python讀excel――xlrd2.python寫excel――xlwt1.讀excel數(shù)據(jù)，包括?期等數(shù)據(jù)#coding=utf-8importxlrdimportdatetimefromdatetimeimportdatedefread_excel():#打開?件wb=xlrd.open_workbook(r"test.xlsx")#獲取所有sheet的名字print(wb.sheet_names())#獲取第?個sheet的表明sheet2=wb.sheet_names()[1]#sheet1索引從0開始，得到sheet1表的句柄sheet1=wb.sheet_by_index(0)rowNum=sheet1.nrowscolNum=sheet1.ncols#s=sheet1.cell(1,0).value.encode("utf-8")s=sheet1.cell(1,0).value#獲取某?個位置的數(shù)據(jù)#1ctype:0empty,1string,2number,3date,4boolean,5errorprint(sheet1.cell(1,2).ctype)print(s)#print(s.decode("utf-8"))#獲取整?和整列的數(shù)據(jù)#第??數(shù)據(jù)row2=sheet1.row_values(1)#第?列數(shù)據(jù)cols2=sheet1.col_values(2)#python讀取excel中單元格內(nèi)容為?期的?式#返回類型有5種foriinrange(rowNum):ifsheet1.cell(i,2).ctype==3:d=xlrd.xldate_as_tuple(sheet1.cell_value(i,2),wb.datemode)print(date(*d[:3]),end="")print("")if__name__=="__main__":read_excel()~運(yùn)?效果2.往excel寫?數(shù)據(jù)#coding=utf-8importxlwt#設(shè)置表格樣式defset_stlye(name,height,bold=False):#初始化樣式style=xlwt.XFStyle()#創(chuàng)建字體font=xlwt.Font()font.bold=boldfont.colour_index=4font.height==namestyle.font=fontreturnstyle#寫?數(shù)據(jù)defwrite_excel():f=xlwt.Workbook()#創(chuàng)建sheet1sheet1=f.add_sheet(u"sheet1",cell_overwrite_ok=True)row0=[u"業(yè)務(wù)",u"狀態(tài)",u"北京",u"上海",u"?州",u"深圳",u"狀態(tài)?計",u"合計"]column0=[u"機(jī)票",u"船票",u"?車票",u"汽車票",u"其他"]status=[u"預(yù)定",u"出票",u"退票",u"業(yè)務(wù)?計"]foriinrange(0,len(row0)):sheet1.write(0,i,row0[i],set_stlye("TimeNewRoman",220,True))i,j=1,0whilei<4*len(column0):#控制循環(huán)：每次加4#第?列sheet1.write_merge(i,i+3,0,0,column0[j],set_stlye("Arial",220,True))#最后?列sheet1.write_merge(i,i+3,7,7)i+=4sheet1.write_merge(21,21,0,1,u"合計",set_stlye("TimeNewRoman",220,True))i=0whilei<4*len(column0):#控制外層循環(huán)：每次加4forjinrange(0,len(status)):#控制內(nèi)層循環(huán)：設(shè)置每??內(nèi)容sheet1.write(i+j+1,1,status[j])i+=4#創(chuàng)建sheet2sheet2=f.add_sheet(u"sheet2",cell_overwrite_ok=True)row0=[u"姓名",u"年齡",u"出??期",u"愛好",u"關(guān)系"]column0=[u"UZI",u"Faker",u"?司馬",u"PDD",u"馮提莫"]#?成第??foriinrange(0,len(row0)):sheet2.write(0,i,row0[i],set_stlye("TimesNewRoman",220,True))#?成第?列foriinrange(0,len(column0)):sheet2.write(i+1,0,column0[i],set_stlye("TimesNewRoman",220,True))f.save("data.xls")if__name__=="__main__":write_excel()~在data.xls種?成了sheet1和sheet2：