Python实现读写Excel和修改Excel的代码

#打开Excek,xlsfile为Excel路径+文件名

boorRead  = xlrd.open_workbook(xlsfile)

#读取sheet,sheet_name为Excel中sheet的名称

sheetRead = boorRead.sheet_by_name(sheet_name)

#读取单元格内容

data = sheetRead.cell_value(row, col)

#创建文件对象

wrbook = xlwt.Workbook(encoding='utf-8', style_compression=0)

#增加sheet

wrsheet = wrbook.add_sheet(sheet_name, cell_overwrite_ok=True)

#向单元格写数据,

wrsheet.write(row,col,data)

#保存文件

wrbook.save(xlsname)

book = xlrd.open_workbook(xlsfile，formatting_info=True)

book_wr = copy(book)

sheet_wr = bookWr.get_sheet(sheet_name)

sheet_wr.write(row,clo,data)

book_wr.save(file_name)