Beispiel #1
0
#coding=utf-8
import os
import openpyxl
import glob
import re
from openpyxl.styles import PatternFill,Border,Side,Alignment,Protection,Font
from openpyxl.styles import Border, Side, PatternFill, Font, GradientFill, Alignment
from openpyxl.styles import Font

alignC = Alignment()
alignC.horz = Alignment(horizontal='general')
alignC.vert = Alignment(vertical='bottom')

alignL = Alignment()
alignL.horz = Alignment(horizontal='left')
alignL.vert = Alignment(vertical='bottom')

alignR = Alignment()
alignR.horz = Alignment(horizontal='right')
alignR.vert = Alignment(vertical='bottom')

dic_Alignment = {'left': alignL, 'center': alignC, 'right': alignR}
dic_Font = {}  # 字体
dic_Border = {}  # 表格边框
dic_Style = {}  # 单元格样式
dic_RowStyle = {}  # 行高
dic_season = {'S':'夏秋',
              'W':'冬春'}

def GetAlignment():