xlsx

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