python使用openpyxl库修改excel表格数据方法

wb = Workbook()#创建工作簿

ws = wb.active#激活工作表

ws1 = wb.create_sheet("Mysheet")#创建mysheet表

ws.title = "New Title"#表明改为New Title

ws.sheet_properties.tabColor = "1072BA"#颜色

ws['A4'] = 4#赋值

d = ws.cell(row=4, column=2, value=10)#赋值

cell_range = ws['A1':'C2']#选择单元格区域

wb.save('test.xlsx')#保存

wr = Write_excel('d:\demo.xlsx')

wr.write('A2','hello')

wr.merge('A1:B3')

font = Font(name=u'宋体', size=14, color=RED, bold=True)

align = Alignment(horizontal='center', vertical='center')

wr.cellstyle('B2', font, align)

rows = [

  (None, 2013, 2014),

  ("Apples", 5, 4),

  ("Oranges", 6, 2),

  ("Pears", 8, 3)

]

for row in rows:

  ws.append(row)

wr.makechart(u"3D Bar Chart", 'E5', 12.5, 7, 2, 1, 3, 4, 1, 2, 4)