To run the excel report, security settings are required for excel application because while working with the excel application we are going to use some of the classes for manipulating the data inside the file. Since the output of the excel report will come as a file. So that to do the manipulation with the file we need to grant the access or rights(Read/Write) to those files.
After following the steps we will be having a full control over the Excel Application.
* We need to grant write privileges to your Web directory for this account (IUSR_machinename since we are using <identity impersonation=true> in web.config) for that add IUSR_machinename as administrator.
* These accounts exist only if Internet Information Server (IIS) is installed on the computer.
A: Screen Layout of Dcomcnfg.exe Excel Property