<p style="line-height: 1.75em;"><span style="font-family: 微软雅黑, "Microsoft YaHei";">import openpyxl
from openpyxl.styles import Side, Border, colors
#定义边框样式
def my_border(t_border, b_border, l_border, r_border):
border = Border(top=Side(border_style=t_border, color=colors.BLACK),
bottom=Side(border_style=b_border, color=colors.BLACK),
left=Side(border_style=l_border, color=colors.BLACK),
right=Side(border_style=r_border, color=colors.BLACK))
return border
#初始化制定区域边框为所有框线
def format_border(s_column, s_index, e_column , e_index):
for row in tuple(sheet[s_column + str(s_index):e_column + str(e_index)]):
for cell in row:
cell.border = my_border('thin', 'thin', 'thin', 'thin')
#给指定区域设置粗匣框线
def set_solid_border(area_list):
for area in area_list:
s_column = area[0]
s_index = area[1]
e_column = area[2]
e_index = area[3]
#设置左粗框线
for cell in sheet[s_column][s_index - 1:e_index]:
cell.border = my_border(cell.border.top.style, cell.border.bottom.style,
'medium', cell.border.right.style)
# 设置右粗框线
for cell in sheet[e_column][s_index - 1:e_index]:
cell.border = my_border(cell.border.top.style, cell.border.bottom.style,
cell.border.left.style, 'medium')
# 设置上粗框线
for row in tuple(sheet[s_column + str(s_index):e_column + str(s_index)]):
for cell in row:
cell.border = my_border('medium', cell.border.bottom.style,
cell.border.left.style, cell.border.right.style)
# 设置下粗框线
for row in tuple(sheet[s_column + str(e_index):e_column + str(e_index)]):
for cell in row:
cell.border = my_border(cell.border.top.style, 'medium',
cell.border.left.style, cell.border.right.style)
if __name__ == '__main__':
wb = openpyxl.load_workbook('test.xlsx')
sheet = wb['Sheet1']
format_border('A', 3, 'D', 10)
set_solid_border([['A', 3, 'D', 5], ['A', 6, 'D', 7], ['A', 8, 'D', 10],
['A', 3, 'A', 10], ['B', 3, 'C', 10], ['D', 3, 'D', 10]])
wb.save('test.xlsx')<br></span></p>
