Compare Files (Diff)
AI-generatedSummary
Compare two Excel files on a specified sheet to identify differences between them.
Inputs
- Binary Property (required) — Name of the binary property containing the first Excel file to compare.
- Binary Property 2 (required) — Name of the binary property containing the second Excel file to compare.
- Sheet Name (required) — Name of the sheet within both Excel files to perform the comparison on.
Output shape
a single JSON object describing the differences between the two files for the specified sheet
The output JSON result is paired with the input item. The operation requires two binary properties containing the Excel files. Errors during processing can be optionally handled with 'Continue on Fail'.
Examples
Example 1: Comparing two Excel files for changes on Sheet1
Set 'Binary Property' to the binary property holding the first file, 'Binary Property 2' to that holding the second file, and 'Sheet Name' to 'Sheet1'. Use the output JSON to explore differences found.