In short: Automate deterministic JSON or CSV comparisons with documented exit codes.
Workbook comparison
Choose Basic, Smart, or Table mode from a terminal or automation script and save deterministic JSON or CSV output. Table mode requires one or more key columns.
- --mode basic|smart|table
- --key-columns ID,SKU
- --format json|csv
- 0: no differences · 1: differences found · 2: invalid input or comparison failure
Compare multiple Excel files at once
Pass two folders with --batch. Use --match filename to pair equal filenames across different folder locations, or --match path to require the same folder location and filename. xlLens never guesses when a filename has multiple candidates; provide explicit pairs with a --mapping JSON file.
- xllens before after --batch --match filename --mode smart
- pairs.json: {"pairs":[{"before":"A/report.xlsx","after":"B/report.xlsx"}]}
- Add --mapping pairs.json for duplicate or renamed files