How can I improve the Process? Help..

[fero9506]

Hi,
i will explain what im trying to optimate with the screenshot and im asking for help… My intention is, instead of updating the excel files with altgr + f9 every time in each folder(I would put them in one folder and have folders in it again with the specific files), i want to do it via knime but yet i couldnt find any solution… These are the first steps i took but it still doesnt work out as i want…

My goal is it, to update the all excel files in the folder(all sheets included, no specific sheet)…
Any suggestion or expierence with the same topic?
Iam a knime newbie and thank you for your time and help. I appreciate that !

[AlexanderFillbrunn]

Hi,
I would take the following approach:

• List all Excel files with the List Files/Folders node
• Loop through files with Table Row To Variable Loop Start
• Read all sheets in the Excel file with the Read Excel Sheet Names node
• Loop through the sheets with another Table Row To Variable Loop Start
• Read Excel with Excel Reader, use flow variable to control the file path and the sheet name
• Update the read data with whichever nodes you need
• Use Excel Writer to write data into the Excel file, again use flow variable to control the file path and the sheet name, select “overwrite” where necessary
• End loop with a Variable Loop End

Kind regards,
Alexander

[fero9506]

thanks for your response, but i do have a small question im sorry…

After i put the Read Excel Sheet Names node, i should put another Table Row To Variable Loop start even i have one before ?
Are those 2 differenct Processes with a interface together or one process ?

Thank you for your help and taking your time to a help a newbie in knime

[AlexanderFillbrunn]

Hi,
That would be one flow, with the loop through the sheet names nested inside the loop through the files.
Kind regards
Alexander

[mlauber71]

@fero9506 this workflow has some basic examples on the left side and additional examples in the links. Maybe you can check them:

Import EXCEL - a meta workflow trying to answer questions about importing...

[fero9506]

Im trying to do it over reald excel sheet names - table row to variable loop start - excel reader - loop end.

Now im just trying to adjust the list files/folders at the beginning to make the process correct but is it possible without putting the excel writer into it ?
Thank you for your time and help. I really appreciate that !

Have a good day

[fero9506]

Maybe i im just considering a bit to much but could you just send me template of it so i can just try to reconstruct the process and adjust my own files that i want to adjust. I will try to improve the process if possible and to transmit it to the other process… If you could help me out by this issue, it would help me out a lot!!! Thanks!!!

[fero9506]

As you see, i couldnt handle it much and tried my best with the connection. The problem is, it always wants a specific sheet name which is not neccessary for me because i just want to just update the file without importing any new dataset or sheet name.

The datasets are already imported, the only thing that i want to do now is to just refresh the file without any import of a sheet name or a dataset. Is this even possible with knime ?

[denisfi]

Hi @fero9506 ,

Did you try something like that?

For each table row loop, it will make the process and at the end, you just link with the variable end loop node to close the process.

Sure that you can add some steps to complete your needs from this flow, but it is an ideia for how can you can go to there…

I didn’t test because we don’t have a sample for you or the workflow to validate it… but I can imagine that can works for you.

BR,

Denis

[fero9506]

Thank you for the response. I will try to do this and will update it here.
The Problem is, i have several sheets that needs to be refreshed and it shouldnt change but from my point now it is, but lets try it out what you just posted here !

I just want to say thank you again because you are helping me out a lot and i appreciate that.

Best Regards

[fero9506]

how can i set the red node from writer to variable loop end ? (im sorry xD)

[denisfi]

Hi @fero9506 ,

Just right click the node to see “show flow variables port” option. 2 dots reds appears on top. The left you use to insert information, the right to export. Just connect the right to the loop node as input.

All nodes have this option ok?

I hope that it can help you.

BR,

Denis