0 dní v řadě · 0 bodů

Tahá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.

Otevřít celou lekciVšechny taháky
python
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 calculated