Recalc Excel for KAP5.x

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 Rename2 ×
Component Input2 ×
Component Output2 ×
Table Row to Variable2 ×
Cell Splitter1 ×
Show all 17 nodes

Extensions

FeatureKNIME Base nodes
FeatureKNIME Javasnippet
FeatureKNIME Quick Forms