37,719
社区成员
发帖
与我相关
我的任务
分享
#!/usr/bin/env python
#-*- coding:UTF-8 -*-
'''
Created on 2014-3-26 下午8:31:06
@author: Metoo
'''
from openpyxl import Workbook
from openpyxl.style import Color, Fill
wb = Workbook()
ws = wb.active
# Create fill
redFill = Fill()
redFill.start_color.index = 'FFEE1111'
redFill.end_color.index = 'FFEE1111'
redFill.fill_type = Fill.FILL_SOLID
ws.conditional_formatting.add2ColorScale('A1:A10', 'min', None, 'FFAA0000', 'max', None, 'FF00AA00')
# Add a three-color scale
ws.conditional_formatting.add3ColorScale('B1:B10', 'percentile', 10, 'FFAA0000'
ws.conditional_formatting.addCellIs('C2:C10', 'lessThan', ['C$1'], True, wb, None, None, redFill)
ws.conditional_formatting.addCellIs('D2:D10', 'between', ['1','5'], True, wb, None, None, redFill)
dxfId = ws.conditional_formatting.addDxfStyle(wb, None, None, None)
ws.conditional_formatting.addCustomRule('E1:E10', {'type': 'expression', 'dxfId': dxfId,
'formula': ['ISBLANK(E1)'], 'stopIfTrue': '1'})
# Check
wb.save("test.xlsx")
from openpyxl import workbook
注意大小写,不是Workbook,好像老版本的openpyxl和新的不一样。
http://stackoverflow.com/questions/9629532/cannot-import-workbook-in-openpyxl