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

1、openpyxl库可以读写xlsx格式的文件，对于xls旧格式的文件只能用xlrd读，xlwt写来完成了。

简单封装类：

from openpyxl import load_workbook
from openpyxl import Workbook
from openpyxl.chart import BarChart, Series, Reference, BarChart3D
from openpyxl.styles import Color, Font, Alignment
from openpyxl.styles.colors import BLUE, RED, GREEN, YELLOW

class Write_excel(object):
    def __init__(self,filename):
        self.filename = filename
        self.wb = load_workbook(self.filename)
        self.ws = self.wb.active

    def write(self, coord, value):
        # eg: coord:A1
        self.ws.cell(coord).value = value
        self.wb.save(self.filename)

    def merge(self, rangstring):
        # eg: rangstring:A1:E1
        self.ws.merge_cells(rangstring)
        self.wb.save(self.filename)

    def cellstyle(self, coord, font, align):
        cell = self.ws.cell(coord)
        cell.font = font
        cell.alignment = al