xlsx

Use openpyxl to create a workbook and append rows parsed from the CSV with the csv module. The bundled xlsx_tool.py script handles this with automatic delimiter detection, header styling, frozen panes, and column width adjustment.

Load the source workbook with openpyxl, apply cell changes, then save to a new output path instead of the source. The set command in xlsx_tool.py accepts Sheet!A1=value pairs and always writes to a separate output file.

No, openpyxl writes formulas but does not compute their results. Use LibreOffice headless mode to open and re-save the workbook, which forces recalculation; the recalc command automates this when soffice is available.

Iterate through all cells with openpyxl and check string values against known error tokens such as #REF!, #DIV/0!, #VALUE!, #NAME?, #N/A, and #NUM!. The inspect command reports each error with its sheet and cell address.

openpyxl does not evaluate formulas, render charts visually, or preserve every advanced Excel feature such as pivot tables in all cases. For visual verification or recalculated values, a LibreOffice round trip is required.