python-openpyxl读写Excel

#juzicode.com/VX公众号:juzicode from openpyxl import load_workbook from openpyxl.styles import Alignment wb = load_workbook('profile.xlsx') ws = wb.active # 设置行列宽高 ws.row_dimensions[2].height = 30 ws.row_dimensions[3].height = 30 ws.column_dimensions['A'].width = 16 ws.column_dimensions['C'].width = 16 # 水平对齐 ws['A1'].alignment = Alignment(horizontal="left") # 靠左对齐 ws['B1'].alignment = Alignment(horizontal="right") # 靠右对齐 ws['C1'].alignment = Alignment(horizontal="center") # 中间对齐 #其他对齐属性设置 ws['A3'].alignment = Alignment(horizontal='right', # 水平对齐 vertical="top", # 垂直对齐 wrap_text=True, # 自动换行 text_rotation=0, # 旋转角度 indent=1, # 缩进 shrink_to_fit=True, # 是否自动缩小 ) ws['C3'].alignment = Alignment(horizontal='right', # 水平对齐 vertical="top", # 垂直对齐 wrap_text=False, # 自动换行 text_rotation=0, # 旋转角度 indent=1, # 缩进 shrink_to_fit=True, # 是否自动缩小 wrap_text设置为False才能看到效果 ) wb.save('profile-对齐.xlsx')