Excel Comment Reader

Reads the cell comments from the specified sheet of the Excel xlsx file.

Limitations
This uses the apache poi 4.1.1 package to access the xlsx file. This requires KNIME 4.7
It is not able to read Excel threaded comments. Where there are threaded comments, only the first comment will be returned.


@takbb Brian Bates 14 June 2023

Options

XLSX File Location

Specify the xlsx file location as a String. This must be a full absolute path to the Escel file

Sheet Name

Specify the name of the worksheet

Nodes

• Cell Splitter2 ×
• String Configuration2 ×
• Column Filter1 ×
• Column Rename1 ×
• Column Resorter1 ×
• Component Input1 ×
• Component Output1 ×
• Extract Context Properties1 ×
• Java Snippet1 ×
• RowID1 ×
• String Manipulation (Variable)1 ×
• Table Creator1 ×
• Ungroup1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available