border class about diagonal option not effect
I want to set diagonal border for A1:A3.In the document,finding the code about:
from openpyxl.styles import Border, Side, PatternFill
workbook = openpyxl.load_workbook('F:/OneDrive/Desktop/2.xlsx')
worksheet = workbook['name1']
border = Border(diagonal=Side(style='thin'))
cell_range = 'A1:A3'
for row in worksheet[cell_range]:
fow cell in row:
cell.border = border
workbook.save('F:/OneDrive/Desktop/3.xlsx')
when i runned this program, i find 3.xlsx not diagonal border of A1:A3,it doesn`t work. but Border another option is ok. like
border = Border(left=Side(style='thin'),
right=Side(style='thin'),
top=Side(style='thin'),
bottom=Side(style='thin'))
it works. so about diagonal option is a bug?, or what?
Edited by Belong