python读取excel文件

来源：互联网发布：用花洒自慰知乎编辑：程序博客网时间：2024/04/30 22:44

一、读excel

import xlrddef open_excel(filename):  # 打开文件xlrd.Book.encoding = "utf-8"try:data = xlrd.open_workbook(filename)return dataexcept Exception, e:print str(e)def excel_table_byindex(file = '1.xlsx', colnameindex=0, by_index=0):data = open_excel(file)table = data.sheets()[by_index]  # 第几个sheetnrows = table.nrows  # 行数ncols = table.ncols  # 列数colnames = table.row_values(colnameindex)  # 某一行数据list1 = []  # 新建一个支持表list2 = []  # 新建一个中立表list3 = []  # 新建一个反对表for rownum in range(1, nrows):row = table.row_values(rownum)  # row是一行的数据if row:app={}  #新建一个字典for i in range(len(colnames)):app[colnames[i]] = row[i]if app['attitude'] == 1:list1.append(app)elif app['attitude'] == 0list2. append(app)elif app['attitude'] == -1list3.append(app)return list1,list2,list3

title = table.col_values(index) # 读取某一列数据

二、写excel

import xlwtbook = xlwt.Workbook(encoding="utf-8", style_compression=0)  # 创建一个workbooksheet = book.add_sheet('1', cell_overwrite_ok=True)  # 添加一个sheetsheet.write(0,0,'title')sheet.write(0,1,'number')sheet.write(0,2,'news')sheet.write(0,3,'ren')sheet.write(0,4,'computer')sheet.write(row, 0, title1[m])sheet.write(row,1,number1[m])sheet.write(row,2,s)sheet.write(row,3,1)book.save(filename)

0 0