1、openpyxl庫可以讀寫xlsx格式的文件，對于xls舊格式的文件只能用xlrd讀，xlwt寫來完成了。

簡單封裝類：

from openpyxl import load_workbookfrom openpyxl import Workbookfrom openpyxl.chart import BarChart, Series, Reference, BarChart3Dfrom openpyxl.styles import Color, Font, Alignmentfrom openpyxl.styles.colors import BLUE, RED, GREEN, YELLOWclass 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 = align  def makechart(self, title, pos, width, height, col1, row1, col2, row2, col3, row3, row4):    ''':param title:圖表名         pos:圖表位置         width:圖表寬度         height:圖表高度    '''    data = Reference(self.ws, min_col=col1, min_row=row1, max_col=col2, max_row=row2)    cat = Reference(self.ws, min_col=col3, min_row=row3, max_row=row4)    chart = BarChart3D()    chart.title = title    chart.width = width    chart.height = height    chart.add_data(data=data, titles_from_data=True)    chart.set_categories(cat)    self.ws.add_chart(chart, pos)    self.wb.save(self.filename)

簡單使用：

1、新建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')#保存 

2、已有excel文件的處理

a、修改excel數據

wr = Write_excel('d:/demo.xlsx') wr.write('A2','hello') 

b、合并單元格

wr.merge('A1:B3') 

c、單元格加入樣式，如字體，顏色等屬性

單元格B2設置宋體，14號，紅色，自動換行，水平居中，垂直居中

font = Font(name=u'宋體', size=14, color=RED, bold=True)align = Alignment(horizontal='center', vertical='center')wr.cellstyle('B2', font, align)

d、創建3d柱狀圖

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) 

可以創建3d柱狀和折線圖表，挺好用的。

官方文檔：https://openpyxl.readthedocs.io/en/latest/usage.html