I have been trying to split my excel sheet based on the variable into multiple sheets but there is an error with the Excel Sheet Appender with fails the execution. On my first try i was able to execute the node and got the excel file but not it is showing error.
WARN Excel Sheet Appender (XLS) 0:4 Unable to write to file ‘L:.metadata\knime\history_XLSWRITER.txt’
ERROR Excel Sheet Appender (XLS) 0:5 Execute failed: C:\Users\Desktop\workbook.xlsx
also my workflow is unable to be saved.
File access problem 'L\KNIME_project\File Reader(#2)\port_1\data.zip(Access is denied)
Please help me out.