excel-ops

Read, clean, analyse and generate Excel workbooks (.xlsx/.csv) without the silent wrong answers. Use when the user has a spreadsheet to parse, summarise, validate, join, convert or produce; when a total from a sheet looks off; when dates shift by a day, numbers arrive as text, formulas read back as objects, or headers are not on row 1; and when generating a report someone else has to open and read. Covers ExcelJS in Node, with equivalents for Python (openpyxl/pandas) and the traps that apply in every language.