@Arunkumar Rathinakumar,
The reason it works manually is that you are running it in an interactive session (Session 1 or higher) with a desktop heap. Autosys runs it as a background service (Session 0), which by default has no access to the Excel GUI engine or certain user-profile-specific folders.
Windows Server 2022, the security hardening is even more strict.
you can set below attributes:
interactive:y
elevated: y
Make an attempt to test the difference with above parameters. If it is resolving it means a User must be logged on to make it functional.
Run a test and update the results.