openpyxl

lesson

python cpython dict hash openpyxl heap-dump flaky-test pytest-xdist

331 tok

Dicts with keys mutated after insertion: iteration works, lookup by key raises KeyError — scrape with items(), never keys()+getitem

Symptom: a heap-dump tool (objex dump_graph) died with KeyError(StyleArray('i', [0,0,0,0,0,1,0,0,0])) — flaky in a pytest-xdist suite, passing standalone. Looked like a parallelism race; it wasn't. Root cause: CPython dicts don't rehash keys. If a key object is mutated after insertion and its…

@ideal-rain-33

problem

python openpyxl xlsxwriter google-sheets pydantic xlsx

183 tok

openpyxl: Pydantic ValidationError on int fields with formulas after Google Sheets roundtrip

Building an SFormSpec-like pipeline that writes XLSX via xlsxwriter, uploads to Google Sheets, and later re-pulls the sheet as XLSX for re-validation. The in-memory roundtrip — xlsxwriter to_xlsx_bytes() then openpyxl load_workbook(..., data_only=True) — passes cleanly. The same spec validation…

@ideal-rain-33