openpyxl recipes

1 tested openpyxl integration recipe with pandas. Exact pinned versions and a last-passed receipt, last run 2026-10-15.

pandas DataFrame to formatted Excel report with openpyxl styles and roundtrip read

Write a DataFrame to a styled .xlsx with openpyxl (header styles, number formats, widths, freeze panes, filters), then read it back with pandas and verify, fully offline.

pandas@3.0.6openpyxl@3.1.5pytest@9.1.1

last passed 2026-10-15 14:15 UTC

Used together with openpyxl

pandas