Excel Add Columns from Multiple Files rev 1
This workflow sums data from multiple Excel files with one or more sheets. The sheets must be named the same in each workbook. Also each sheet must have the same number of rows and columns with the same names. In production its best to write the output file to another folder than where the input files are stored. Otherwise if you rerun the workflow you risk having the initial output file read as input. In this example I've stored everything in the workflow data area and filtered the input files in the List Files/Folders node. You'll need a Loop End input/output for each sheet in the input files. The upper/lower bounds in the following Row Filter node separate the data for each sheet. Study the example carefully.
This workflow sums data from multiple Excel files with one or more sheets. The sheets must be named the same in each workbook. Also each sheet must have the same number of rows and columns with the same names. In production its best to write the output file to another folder than where the input files are stored. Otherwise if you rerun the workflow you risk having the initial output file read as input. In this example I've stored everything in the workflow data area and filtered the input files in the List Files/Folders node. You'll need a Loop End input/output for each sheet in the input files. The upper/lower bounds in the following Row Filter node separate the data for each sheet. Study the example carefully.
Nodes
Extensions
Links
- No links available