Security Setting for Excel

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.

 

Step 1:-

 

    * 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.

 

Step 2:-

 

1. Click Start, click Run, and then type DCOMCNFG.exe .Select the Microsoft Excel Application that we want to automate.
2. Click Properties to open the property dialog box for this application.
3. Click the Security tab. Verify that Use Default Access Permissions and Use Default Launch Permissions are selected.
4. Click the Identity tab. Verify that The Launching User is selected.
5. Click OK to close the property dialog box and return to the main applications list dialog box.
6. In the DCOM Configuration dialog box, click the Default Security tab.
7. Click Edit Defaults for access permissions. Verify that the following users are listed in the access permissions, or add the users if they are not listed:
   
   SYSTEM
   INTERACTIVE
   Everyone
   Administrators
   OfficeAutomationUser
   IUSR_<machinename>*
   IWAM_<machinename>*

* These accounts exist only if Internet Information Server (IIS) is installed on the computer.

 

A: Screen Layout of Dcomcnfg.exe Excel Property