import openpyxl
from openpyxl.styles import Font
wb = openpyxl.load_workbook()
sheet = wb['Sheet1']
fontObj1 = Font(name=u'宋体', bold=True, italic=True, size=24)
sheet['A2'].font = fontObj1
sheet['A2'] = '宋体、粗体、斜体、字体大小为 24'
fontObj2 = Font(name=u'楷书', bold=False, italic=False, size=32)
sheet['A3'].font = fontObj2
sheet['A3'] = '楷书、字体大小为 32'