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