when I write the result into excel file ( remote , office365) by knime server execute , will execute fail due to access locked, so how to fix this issue?
thanks for reaching out to KNIME I just tried to reproduce your issue, could it be that you have the file open locally or in the browser while attempting to write your result into this file? You can’t write into the file when it is open somewhere else.
Yes, I use office 365, the excel file save in One Drive, due to the result save to excel file , it i will pop up alarm “access locked” when someone open the execel file , I want to how to handle this issue .
I am afraid, I think there is not much you can do about this issue. You potentially could execute the workflow during a time in which the file is unlikely to be open or you could copy the original file and write into the copy of the file and distribute this file in some way to the end user.