openpyxl修改原来的表格内容实例

import openpyxl wb=openpyxl.load_workbook('aike.xlsx') sheet=wb.get_sheet_by_name('b_gy_48') row_max=sheet.max_row print row_max for r in range(1,row_max): j=sheet.cell(row=r,column=6).value if (type(j)==int or type(j)==float or type(j)==long): sheet['F'+str(r)].value=j*(a number) wb.save('b_gy.xlsx')