Got a task ahead,
I’m looking at applying a worksheet to a folder, taking a simple worksheet with some formulas, and applying it to a folder full of more complex files.
Id want these worksheet to allow the formula to apply and then pull out a row from each file and paste that into a separate Excel file for each building up a data set.
Is this possible? Ive just started to use Knime and cant seem to figure it out.
You can loop through all the files in your folder and load them into KNIME and apply logic with KNIME formulas/nodes on each sheet within the loop
Any info as to how to go about it?
Or a rough start at least?
For reading multiple excel sheets you might want to have a look
to get started