import csv, io
from datetime import datetime
from openpyxl import Workbook, load_workbook
from openpyxl.chart import BarChart, Reference
from openpyxl.styles import Font, PatternFill
csv.DictReader(io.StringIO(text), delimiter=";") # rows as dicts
float("79,50".replace(",", ".")) # decimal comma
datetime.strptime("03.03.2026", "%d.%m.%Y").date() # ValueError if invalid
wb = Workbook(); wb.remove(wb.active) # start without the default sheet
ws = wb.create_sheet("Data")
ws.cell(2, 4, text).data_type = "s" # never a formula
ws.cell(2, 7, "=E2*F2").number_format = '#,##0.00 "Kč"'
ws["B2"].number_format = "DD.MM.YYYY"
ws.freeze_panes = "A2"; ws.auto_filter.ref = "A1:G8"
ws.column_dimensions["A"].width = 14
"=SUMIF(Data!$C:$C,A2,Data!$G:$G)" # English names, commas
chart = BarChart(); chart.x_axis.delete = False; chart.y_axis.delete = False
chart.add_data(Reference(ws, min_col=4, min_row=1, max_row=4), titles_from_data=True)
chart.set_categories(Reference(ws, min_col=1, min_row=2, max_row=4))
ws.add_chart(chart, "F2")
load_workbook(path) # formulas as text
load_workbook(path, data_only=True) # cached results, None if never calculatedTahák · Python · Užitečné knihovny
Mise: automatický report do Excelu
Ze špinavého exportu objednávek postavíš hotový sešit se souhrnem, vzorci, grafem, seznamem chyb a kontrolou výsledku.