Good morning KNIME world, I’m new here and I’m using KNIME for hobby for 1 year to find licensed software alternative solution. I used KNIME successfully for MS/MS data extraction with better result than licensed software. Now I’m trying to do something different. We have a big excel file we too many data inside (ex. Assigner, Data, TubeID, etc) and I would like to generate another excel file with sheet for every for ex Assigner. I found the way to do it. The problem is that I need to do this operation every week to have a final .xls with all months data inside. The problem is that every time I made this operation, it overwrite the previous file instead of append on it. Do you have any solution for this? There is an Append option on Excel Writer node, but doesn’t work with Sheets. Here you can see the workflow. Capture|667x500 Thank you for your time!

Hi Matt, That depends on the problem. If every sheet is treated the same way, no extra nodes are necessary. You can also put everything for a single sheet into a component to make it easily reusable and parameterizable. Kind regards, Alexander

Data extraction from .xls file/s

KNIME Analytics Platform

mlauber71 December 18, 2020, 4:54pm 12

@Matt9301 there is a way to do this with the use of Python pandas and openpyxl

You would have to provide an existing excel file and a sheet name and then sheets with the same structure.

3 Likes

Writer Node Issues

java heap error when using write to excel template node

Appending all worksheets in excel excel file into 1 master worksheet

Memory usage - Excel Cell Updater \Read Sheet Names Nodes

Adding Some columns into one excel sheet