i got on how to do this. I had to set NETWORK SERVICES permission on the EXCEL DCOM in the server.
the next issue is, the NETWORK SERVICES locks the excel file the moment it is created and this creates opening, and deleting the excel file impossible.
well i found out that adding
solves the problem of the file being locked.
and its all fine now