python读取excel文件

#-*- coding: utf-8 -*- import xlrdimport xlwtfrom datetime import date,datetime#print 'a'def read_excel():workbook = xlrd.open_workbook('demo1.xls')#table = data.sheets()[0]print workbook.sheet_names()sheet2_name = workbook.sheet_names()[0]#sheet2=workbook.sheet_by_index(0)#sheet2=workbook.sheet_by_name('sheet2')print sheet2.name,sheet2.nrows,sheet2.ncols#rows = sheet2.row_values(0)cols = sheet2.col_values(2)print rowsprint colsprint sheet2.cell(0,3).value.encode('utf-8')print sheet2.cell_value(0,3).encode('utf-8')print sheet2.row(0)[3].value.encode('utf-8')#print sheet2.cell(0,3).ctypeprint sheet2.cell(0,1).ctypedef write_excel():f = xlwt.Workbook()sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True)row0=[u'aaa',u'aaa2',u'aaa3',u'没有啊',u'aaa5',u'aaa6']row1=[u'aaab',u'aaab2',u'aaab3',u'没b有c啊',u'aaa5b',u'aaa6b']for i in range(0,len(row0)):sheet1.write(0,i,row0[i])#for i in range(0,len(row1)):sheet1.write(1,i,row1[i])#sheet2 = f.add_sheet(u'sheet2',cell_overwrite_ok=True)row0 = [u'业务',u'状态',u'北京',u'上海',u'干州',u'深圳',u'状态小计',u'合计']column0 = [u'机票',u'船票',u'火⻋票',u'汽⻋票',u'其它']status = [u'预订',u'出票',u'退票',u'业务小计']for i in range(0,len(row0)):sheet2.write(0,i,row0[i])#i,j=1,0while i < 4*len(column0) and j < len(column0):sheet2.write_merge(i,i+3,0,0,column0[j])sheet2.write_merge(i,i+3,7,7)i += 4j += 1#sheet2.write_merge(21,21,0,1,u'合计')i = 0while i < 4*len(column0):for j in range(0,len(status)):sheet2.write(j+i+1,1,status[j])i+=4#f.save('demo1.xls')print 'ok'if __name__ == '__main__':write_excel()#read_excel()