ComfyUI Node: Spreadsheet OutputList

Spreadsheet OutputList:

The SpreadsheetOutputList node is designed to facilitate the creation of output lists from various spreadsheet formats, including .csv, .tsv, .ods, .xlsx, and .xls. This node leverages the powerful data manipulation capabilities of the pandas library, specifically using the read_excel and read_csv functions, to read and process spreadsheet files. By converting spreadsheet data into output lists, this node allows you to efficiently manage and utilize data within your AI art projects. The primary benefit of this node is its ability to handle multiple spreadsheet formats and its flexibility in selecting specific rows and columns, making it a versatile tool for data extraction and manipulation. This node is particularly useful for artists and creators who need to integrate structured data into their workflows without delving into complex programming tasks.

Spreadsheet OutputList Input Parameters:

rows_and_cols

This parameter specifies the indices and names of rows and columns in the spreadsheet that you wish to select. It supports a flexible syntax that allows you to reference specific sheets and cells using a combination of letters and numbers, such as A, 1, AB, or $MySheet.123. The default value is "A B C D", which selects the first four columns. This parameter is crucial for determining which parts of the spreadsheet are converted into output lists.

header_rows

The header_rows parameter allows you to ignore a specified number of rows at the top of the spreadsheet. This is useful when your spreadsheet contains header information that you do not want to include in the output lists. The default value is 1, with a minimum of 0 and a maximum of 65535. This parameter is only used if you specify a column in rows_and_cols.

header_cols

Similar to header_rows, the header_cols parameter lets you ignore a specified number of columns at the beginning of the spreadsheet. This is helpful when the first few columns contain metadata or other non-essential information. The default value is 1, with a minimum of 0 and a maximum of 65535. This parameter is only used if you specify a row in rows_and_cols.

select_nth

The select_nth parameter allows you to select only the nth entry from the specified rows or columns, where the index is 0-based. This can be particularly useful when combined with patterns like PrimitiveInt+control_after_generate=increment. The default value is -1, which means all entries are selected, with a range from -1 to 65535.

string_or_base64

This parameter accepts either a CSV/TSV string or a spreadsheet file encoded in base64 format. It is designed to handle multiline input and provides a placeholder to guide you in loading files as base64 using the Load Any File node. This parameter is essential for feeding the node with the data it needs to process and convert into output lists.

Spreadsheet OutputList Output Parameters:

list_a

This output parameter represents the first list extracted from the specified rows and columns of the spreadsheet. It is an output list that can be used in subsequent nodes for further processing or analysis.

list_b

Similar to list_a, this parameter provides the second list extracted from the spreadsheet. It allows you to work with multiple data sets simultaneously, enhancing the node's versatility.

list_c

The list_c parameter outputs the third list from the spreadsheet, offering additional flexibility in handling and manipulating data within your project.

list_d

This parameter outputs the fourth list from the spreadsheet, completing the set of lists that can be generated by this node. It ensures that you have access to a comprehensive range of data extracted from your spreadsheet.

count

The count parameter outputs the number of items in the longest list generated by the node. This provides a quick reference to the size of the data set you are working with, which can be useful for validation and further processing.

Spreadsheet OutputList Usage Tips:

• Use the rows_and_cols parameter to precisely select the data you need from your spreadsheet, ensuring that you only extract relevant information for your project.
• When working with spreadsheets that contain headers or metadata, adjust the header_rows and header_cols parameters to exclude these from your output lists, simplifying your data set.
• If you need to focus on a specific entry within your selected data, utilize the select_nth parameter to isolate that entry, streamlining your workflow.

Spreadsheet OutputList Common Errors and Solutions:

Error decoding base64 data

• Explanation: This error occurs when the input data is not correctly encoded in base64 format, which is necessary for processing spreadsheet files.
• Solution: Ensure that your spreadsheet file is properly encoded in base64 before inputting it into the node. Use the Load Any File node to assist with this process.

Invalid row or column selection

• Explanation: This error arises when the rows_and_cols parameter contains invalid or incorrectly formatted references to rows or columns.
• Solution: Double-check the syntax of your rows_and_cols input, ensuring that it follows the correct format and references existing rows and columns in your spreadsheet.

Pandas read error

• Explanation: This error can occur if the spreadsheet file is corrupted or not supported by the pandas read_excel or read_csv functions.
• Solution: Verify that your spreadsheet file is intact and in a supported format. If necessary, try converting the file to a different format and reattempt the operation.