#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():