I wanted to copy horizontally the details for line 35 of the tab. Note that I have 30 files with the same tab name and the same line number which is line 35.
Can I know which node should I use?
Hey @TLKNW , thanks for posting it 
The latest KNIME Analytics Platform 5.1 release includes a group of nodes that are particularly helpful for spreadsheet users.
You can easily download and install 
the latest version of KNIME Analytics Platform on your local machine.
In addition, you can find a collection page in the Community Hub that provides blueprints and other resources to assist you in completing your spreadsheet tasks within KNIME.
If you’re looking for a node for your specific case, the Table Cropper node is the one I would use.
To reproduce your use case, you can download the below example workflow and execute it on your computer.
The workflow begins by listing all the Excel files in your folder and then using a loop to read each via the Excel Reader node. For each iteration, the Table Cropper node is used to extract the target row, and the final output is a KNIME table with all of the rows that can be outputted wherever you need, such as an Excel or CSV file.
I hope this information has been helpful.
Depending on file location or file name similarities, you can typically do all of this with just the 1 excel reader node. You can read in all excel files within a folder / sub folders and then use the file filter options (if necessary) to focus in on just your targets using a Regex filter. Then you can go to read in by row and select just that target row in each file.
I would also select Append file name column so that you can see which row came from which file.
1 Like
Hey @iCFO ,
Yes, you are totally right 
.
It is even more straightforward to use a single Excel Reader node .
I have updated the workflow @TLKNW to show how to configure the Excel Reader node in case.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.