ws = wb.create_sheet()
for irow in range(5):
    ws.append([True, datetime.datetime.now(), 'test', 1, 1.25, '=D1+E1'])
wb.save('output.xlsx')
Set cell format and style using Optimized Writer in openpyxl