Export to Excel and Word Configuration

How to configure web server that used by web application to export data to Excel or Word ?

Below is step by step :

To Excel :

1. Click Run – type dcomcnfg  – show Component Services menu.

2. Right Click on DCOM Config tree – Microsoft Excel Application – select Properties.

3. On the security tab add user ASP.Net Machine Account, IISUser, and Administrators in each group.

4. Click OK – close Component Services menu.

 

To Word :

1. Click Run – type dcomcnfg  – show Component Services menu.

2. Right Click on DCOM Config tree – Microsoft Office Word Document – select Properties.

3. On the security tab add user ASP.Net Machine Account, IISUser, and Administrators in each group.

4. On the identity tab – select This User, and type Administrator username & password .

5. Click OK – close Component Services menu.

 

Ok, may it helps

Thanks