excel_row_diff
Actually a column comparison — see excel_column_diff first
- count
- count_data
- count_finish
This node's name says "row" but it compares two columns, top to bottom. That's not a guess - its own parameters are named col_data and col_finish, and its description explicitly says it counts consecutive non-empty cells going down a column. It's the mirror image of excel_column_diff in the same pack, which despite its name compares two rows - the naming on this pair is swapped, so if you landed here expecting a row comparison, excel_column_diff is the node you actually want.
How it works
Once you know what it actually does, it's simple: give it two column numbers, col_data and col_finish, and it counts down each one from the top, tallying consecutive non-empty cells until it hits a blank. count_data is the tally for the first column, count_finish for the second, and count is the difference between them. This is the same "how many are still missing" pattern as its sibling, just oriented for a sheet layout where your batch data runs down columns instead of across rows - one column per item, tracking what's queued versus what's actually been completed.
The inputs and outputs that matter
excel_path/sheet_name- the file and sheet to read.col_data/col_finish(INT, min 1) - the two columns being compared, counted top to bottom starting from row 1.- Outputs:
count(count_dataminuscount_finish), pluscount_dataandcount_finishas raw numbers.
How to install it
Bundled with the full pack. Via ComfyUI Manager: search "ComfyUI-Apt_Preset" → Install → restart. Manually:
cd ComfyUI/custom_nodes
git clone https://github.com/cardenluo/ComfyUI-Apt_Preset.git
Windows: run install.bat from the cloned folder through ComfyUI's embedded Python. Linux/Mac: activate your ComfyUI venv and install requirements from that folder by hand. Restart ComfyUI. Like the rest of the excel_* nodes here, this one needs a Python .xlsx library (most likely openpyxl) that gets pulled in during that install step - if just the excel nodes fail to load while the rest of the pack works, check the console for an import error naming that.
Common issues & troubleshooting
You wanted a row comparison and got a column one (or vice versa). This is the pack's one real naming trap: excel_row_diff diffs columns, excel_column_diff diffs rows. Swap to the other node if the result orientation doesn't match what you're actually tracking in your sheet.
Count is lower than the number of items you know you've entered. The scan stops at the first blank cell going down the column - it's consecutive non-empty cells from the top, not a total count of filled cells anywhere in the column. A single accidental gap partway down will truncate the count right there.
File or sheet name errors come back silently. excel_path and sheet_name are plain strings with no built-in validation - double-check the path resolves relative to wherever ComfyUI's working directory actually is, and that the sheet name matches exactly (case and all), since a mismatch tends to surface as an empty/zero result rather than a loud error.
Inputs (4)
| Name | Type | Default | Description |
|---|---|---|---|
| excel_path | STRING | excel_file_path.xlsx | — |
| sheet_name | STRING | Sheet1 | — |
| col_data | INT | 1 | — |
| col_finish | INT | 1 | — |
Outputs (3)
| Name | Type | Description |
|---|---|---|
| count | INT | — |
| count_data | INT | — |
| count_finish | INT | — |