@shreya welcome to the KNIME forum.
From what you write about the error messages I would recommend you check you paths and the settings where to write your Excel files. And maybe also the integrity of the KNIME setup itself.
As it happens I have just built a workflow for a different question that might help you.
The excel sheet names would come from the Loop Group