Recalculate Excel

Component to recalculate Excel xlsx spreadsheet

This uses Java Apache POI library to attempt recalc of a selected xlsx spreadsheet. The POI library changes between KNIME versions and whilst working with any specific KNIME version cannot be guaranteed, this component does attempt to locate the POI libraries on the installed KNIME AP version.

@takbb 20 September 2024

Please contact me, @takbb, via the KNIME Community forum if it does not work on your specific version. I will assist if I can.

Options

Path to Excel xlsx file: Enter the path to the Excel (.xlsx) file

Input Ports

This node has no input ports

Output Ports

: No description for this port available.

Nodes

Column Rename3 ×
Component Input3 ×
Component Output3 ×
GroupBy2 ×
String Manipulation2 ×
Show all 23 nodes

Extensions

FeatureKNIME Base nodes
FeatureKNIME Basic File System Connectors
FeatureKNIME Javasnippet
FeatureKNIME Quick Forms