Can't change DEFAULT_FONT Calibri
I would like to change the default Calibri font to Arial But nothing seems to have an effect.
A workaround is iterating over all cells, but this is very slow.
Things i've tried so far:
Changing DEFAULT_FONT doesn't have a effect
from openpyxl import Workbook
from openpyxl.styles import Font
from openpyxl.styles import NamedStyle
from openpyxl.styles import DEFAULT_FONT
DEFAULT_FONT.name = "Arial"
Changing built-in 'Normal' and 'Default' style doesn't have a effect
NamedStyle(name='Normal').font.name = "Arial"
NamedStyle(name='Default').font.name = "Arial"
Removing the default worksheet doesn't have a effect
wb = Workbook()
wb.remove(wb.active)
ws = wb.create_sheet("TEST")
Only this works, but is not the desired way
for ws in ( ws1 , ws2 , ws3 , ws4 ):
for col in range(1,30):
for row in range(1,2000):
ws.cell(row,col).font = Font(name="Arial")
Edited by ReMi