example_openpyxl.py

nombre_archivo = "blah.xlsx"
wb = Workbook()
ws1 = wb.active
ws1.title = titulo
header = NamedStyle(name="header")
header.font = Font(bold=True)
header.border = Border(bottom=Side(border_style="thin"))
header.alignment = Alignment(horizontal="center", vertical="center")

for i in range(len(columnas)):
    col = i + 1
    titulo = columnas[i][0]
    cell = ws1.cell(column=col, row=1, value=titulo)
    cell.style = columnas[i][1]
    ws1.column_dimensions[get_column_letter(col)].width = len(titulo)

row_excel = 2
for l in lineas:
    for i in range(len(l)):
        col = i + 1
        cell = ws1.cell(column=col, row=row_excel, value=l[i])
        cell.style = columnas[i][1]
    row_excel += 1
wb.save(filename=dest_filename)