Categories to Excel Sheets

This component creates the Excel file and writes the selected columns of the input table to the separate sheets of this file. Each sheet contains a subset of the data as defined by the categories in a selected column.

Options

Overwrite existing file

Existing files will be overwritten if this option is enabled. Otherwise the node will fail during execution to retain the original file and to avoid unintentional overwrite.

Columns to be written into the Excel file

Select whether all or only a subset of columns will be written into the file. By default all columns will be written.

Split the table based on

Select the column on which the split of the table to different Excel sheets will be based. Rows with missing values in the selected column will be written to the separate Excel sheet called "Unknown".

Location (the directory where the file will be located)

Enter a path to a file. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (LocalFile System on Windows).

Extension

Select the extension of the output Excel file. Two formats are supported:%%00010• .xls format: This is the file format which was used by default up until Excel 2003. The maximum number of columns held by a spreadsheet of this format is 256 (all additional columns in the datatable are truncated). If the input data table has more than 65536 rows, it is split into multiple spreadsheets (all stored in the created workbook). %%00010• .xlsx format: The Office Open XML format is the file format used by default from Excel 2007 onwards. %%00010

File name

Enter the name of the output Excel file.

Nodes

• Breakpoint4 ×
• Excel Writer4 ×
• Rule Engine Variable4 ×
• Column Rename3 ×
• Rule Engine3 ×
• Show all 37 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Excel Support
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available