Diff workbooks
diff_workbooksCompare two .xlsx workbooks cell by cell and return JSON differences for added, removed, changed value/formula, and format-only cells, so you can see what changed between versions.
Instructions
Compare two .xlsx files cell by cell and return the differences as JSON: {summary, added, removed, changed, format_changed}. Cells are matched on (sheet title, cell ref); changed covers value and formula changes, and format-only changes are listed separately. Use it to see what changed between two versions of a file, such as before and after an edit. For problems inside one workbook use audit_workbook; to undo edits in a session use restore_session. Provide exactly one of before_path/before_url/before_base64 and one of after_path/after_url/after_base64. Both files are uploaded to and parsed on the Basis API (up to 20 MB each) and count against the API key's parse quota; nothing is stored.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| after_url | No | URL to fetch the second (after) .xlsx file from | |
| after_path | No | Local filesystem path to the second (after) .xlsx file | |
| before_url | No | URL to fetch the first (before) .xlsx file from | |
| before_path | No | Local filesystem path to the first (before) .xlsx file | |
| after_base64 | No | Base64-encoded bytes of the second (after) .xlsx file | |
| before_base64 | No | Base64-encoded bytes of the first (before) .xlsx file | |
| include_format | No | Report cells whose only change is number format (default true) |