Looking to Combine multiple Worksheets into one file after applying worksheet to each

KNIME Analytics Platform
1

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.

2

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
br

3

Any info as to how to go about it?

Or a rough start at least?

4

For reading multiple excel sheets you might want to have a look
e.g here

to get started
br

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.