I want to write an excel sheet in excel A which has only one sheet to excel B. I select the excel in excel writer by knime path of “File Upload Widget”. I choose the append option as writing options but it does not write although it looks worked. When I select the file in excel writer manually(not by file upload widget path), it appends it. Is it a bug? I use v4.7.8
Note : When I select the “fail” option in if sheet exists part and run workflow twice, it gives error that The workbook already contains a sheet named ‘Fake_Sheet’
So first on your note, that is expected behavior as when you select fail, if the sheet already exists, the node will just fail (which is why you see it happen after you run it a second time as the first time you run it creates the sheet, and the second time you run it, it sees that the sheet is already there and fails the node)
Second, so on why doesn’t it modify the excel document but manually selecting the file does. When you use file upload widget, you are not pointing it at the actual file. If you look in your knime workspace on file explorer, you will find a copy that is made of the file you uploaded → you should be able to see the sheet being appended there. Here I showcase below:
You can see that I uploaded a excel from my desktop and appended a sheet. You can find that excel file with the appended sheet in my tmp folder under the workflow in knime-workspace.
A simple thing to get it easily would be to attach a ‘File Download Widget’ and pass the same flow variable to it.
If you want to modify the actual file, you can use something like ‘List Files/Folders’ node to grab the path to original file:
