Print reports to Excel under IIS

before reading this article, please read an article ". NET for Excel report printing ".

The previous article, ". NET for Excel reports describes how to print a report to an Excel file. To publish your project through IIS, you need to continue with the following configuration. This article mainly describes how to set up an Excel program on a server that is allowed to be invoked in IIS. Report printing can be applied in a real project only if these configurations are set.

The first step:

Install Office Excel software on the server.

In Start, run, enter DCOMCNFG to start Component Services.

Double-click Component Services, computer, my Computer, and then DCOM Config.

In DCOM configuration, locate the Microsoft Excel application, right-click on it, and then tap properties to bring up the Microsoft Excel Application Properties dialog box.

If you determine that a Microsoft Office Excel program is already installed on your computer, your computer's system is a win7 64-bit system, but you find that you cannot find a Microsoft Excel application in DCOM configuration. Please refer to the following methods:

Enter COMEXP.MSC-32 in Start, run to start Component Services so that you can find the Microsoft Excel application under DCOM configuration.

Step Two:

After you open the Properties dialog box for a Microsoft Excel application, you primarily modify its security and identity.

Change the identity setting to: Interactive user

Open the Security dialog box and set access permissions first. The project is primarily deployed to IIS. Permission settings are required for users of IIS.

Click: Edit-Add., Advanced-Instant query. Select the user for IIS and assign permissions to the user. ：

In the same way as above, set the startup and activation permissions to complete the permissions settings for the IIS user.

Step Three:

Publish a project in visual Studio2010 that runs without errors to IIS.

Browse the Default.aspx page, click on the report printing can be achieved. Tests can be accessed from other computers on the same LAN, so that we can easily print out Excel reports in real-world projects.

Print reports to Excel under IIS