基本说明
1.文本水平对齐
2.文本垂直对齐
3.其它对齐
水平对齐
from openpyxl.styles import Alignment
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws.title = '测试专用sheet'
ws['B1'] = '两端对齐'
a1 = ws['B1']
a1.alignment = Alignment(horizontal='justify')
ws['B2'] = '填满对齐'
a1 = ws['B2']
a1.alignment = Alignment(horizontal='fill')
ws['B3'] = '填满对齐填满对齐填满对齐填满对齐'
a1 = ws['B3']
a1.alignment = Alignment(horizontal='fill')
ws['B4'] = '左对齐'
a1 = ws['B4']
a1.alignment = Alignment(horizontal='left')
ws['B5'] = '右对齐'
a1 = ws['B5']
a1.alignment = Alignment(horizontal='right')
ws['B6'] = '一般对齐'
a1 = ws['B6']
a1.alignment = Alignment(horizontal='general')
ws['B7'] = '一般对齐一般对齐一般对齐一般对齐'
a1 = ws['B7']
a1.alignment = Alignment(horizontal='general')
ws['B8'] = '居中对齐'
a1 = ws['B8']
a1.alignment = Alignment(horizontal='center')
ws['B9'] = '分散对齐'
a1 = ws['B9']
a1.alignment = Alignment(horizontal='distributed')
wb.save('alignment.xlsx')
保存结果如下：
垂直对齐
from openpyxl.styles import Alignment
from openpyxl import Workbook
wb = Workbook()
ws2 = wb.create_sheet(title='垂直对齐测试sheet')
ws2['A1'] = '底部对齐'
a1 = ws2['A1']
a1.alignment = Alignment(vertical='bottom')
ws2['B2'] = '居中对齐'
a1 = ws2['B2']
a1.alignment = Alignment(vertical='center')
ws2['C3'] = '顶部对齐'
a1 = ws2['C3']
a1.alignment = Alignment(vertical='top')
wb.save('alignment.xlsx')
保存结果如下：
其它对齐
from openpyxl.styles import Alignment
from openpyxl import Workbook
wb = Workbook()
ws3 = wb.create_sheet(title='其它对齐测试sheet')
ws3['A1'] = '我要旋转30°'
a1 = ws3['A1']
a1.alignment = Alignment(text_rotation=30)
ws3['B2'] = '我不换行我不换行'
ws3['C3'] = '我要换行我要换行'
a1 = ws3['C3']
a1.alignment = Alignment(wrap_text=True) # 是否换行
ws3['D4'] = '我会自己调整大小'
a1 = ws3['D4']
a1.alignment = Alignment(shrink_to_fit=True)
ws3['E5'] = '缩进两个字符'
a1 = ws3['E5']
a1.alignment = Alignment(indent=2)
wb.save('alignment.xlsx')
保存结果如下：
