ComfyUI Node
Spreadsheet OutputList
Creates multiple OutputLists from a spreadsheet (`.csv .tsv .ods .xlsx .xls`). You can use the `Load any File` node to load a file in base64-encoding. Internally uses *pandas* [read_excel](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html) and [read_csv](https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html) to load spreadsheet files. All lists use(s) `is_output_list=True` (indicated by the symbol `𝌠`) and will be processed sequentially by corresponding nodes.
Spreadsheet OutputList
- list_a
- list_b
- list_c
- list_d
- count
◄rows_and_colsA B C D►
◄header_rows1►
◄header_cols1►
◄select_nth-1►
◄string_or_base64►
CategoryUtility
Inputs (5)
| Name | Type | Default | Description |
|---|---|---|---|
| rows_and_cols | STRING | A B C D | Indices and names of rows and columns in the spreadsheet. Note that in spreadsheets rows start at 1, columns start at A, whereas OutputLists are 0-based (in `select-nth`). |
| header_rows | INT | 10–65535 | Ignore the first x rows in the list. Only used if you specify a col in `rows_and_cols`. |
| header_cols | INT | 10–65535 | Ignore the first x cols in the list. Only used if you specify a row in `rows_and_cols`. |
| select_nth | INT | -1-1–65535 | Only select the nth entry (0-based). Useful in combination with the `PrimitiveInt+control_after_generate=increment` pattern. |
| string_or_base64 | STRING | CSV/TSV string or spreadsheet file in base64 (for `.ods .xlsx .xls`). Use `Load Any File` node to load a file as base64. |
Outputs (5)
| Name | Type | Description |
|---|---|---|
| list_a | STRING | use(s) `is_output_list=True` (indicated by the symbol `𝌠`) and will be processed sequentially by corresponding nodes. |
| list_b | STRING | use(s) `is_output_list=True` (indicated by the symbol `𝌠`) and will be processed sequentially by corresponding nodes. |
| list_c | STRING | use(s) `is_output_list=True` (indicated by the symbol `𝌠`) and will be processed sequentially by corresponding nodes. |
| list_d | STRING | use(s) `is_output_list=True` (indicated by the symbol `𝌠`) and will be processed sequentially by corresponding nodes. |
| count | INT | Number of items in the longest list. |