Failed to Load file or assembly "Microsoft. Office. Interop. Excel, Version = 11.0.0.0, Culture = neutral

Zang
Failed to Load file or assembly "Microsoft. Office. Interop. Excel, Version = 11.0.0.0, Culture = neutral, PublicKeyToken = 71e9bce111e9429c" or one of its dependencies. The system cannot find the specified file.

Problem analysis: the installed Microsoft. Office. Interop. Excel version is incorrect.

Solution: Modify the Web. Config file.

(1) Find the Web. Config file in the installation directory.

(2) Delete the following code in the Web. Config file:

 

<Add assembly = "office, Version = 11.0.0.0, Culture = neutral, PublicKeyToken = 71E9BCE111E9429C"/>

 

<Add assembly = "Microsoft. Vbe. Interop, Version = 11.0.0.0, Culture = neutral, PublicKeyToken = 71E9BCE111E9429C"/>

 

<Add assembly = "stdole, Version = 7.0.3300.0, Culture = neutral, PublicKeyToken = B03F5F7F11D50A3A"/> </assemblies>

 

 

 

EXCEL export problems

1. An error occurred while exporting the EXCEL table.

 

 

 

Solution: In the DCOM component service, grant the ASP. NET Operation permission to the MICROSOFT. EXCEL component.

(1) "Start> program> Management Tools> component services ".

(2) Expand "component service> Computer> my computer", right-click "my computer", and select "properties ".

(3) In the pop-up "My Computer properties" box, select "com Security ".

(4) In "Access Permissions", click "Edit restrictions" and select "ASP. NET user (or NETWORK Service user), and check all "Allowed" items. As follows:

 

 

 

In "Start and activate Permissions", click "Edit restrictions" and select "ASP. NET user (or NETWORK Service user), and check all "Allowed" items. As follows:

 

 

⑹ Return to the "component service" window. Under "My Computer> DCOM configuration", right-click "micrsoft excel application" and select "properties ".

In the dialog box that appears, select security items and set "Start and activate Permissions", "Access Permissions", and "Configure permissions" to "Custom", as shown below:

 

 

 

 

 

Click "Start and activate Permissions", "Access Permissions", and "edit" for each item of "Configure permissions". In the displayed dialog box, add "ASP. NET user (or NETWORK Service user ). Select all the hooks that are allowed.

 

⑼ Return to the "micrsoft excel application properties" window, and select "start user" in the "ID" item, as shown below:

 

 

 

Confirm and click OK.

 

This article from the CSDN blog, reproduced please indicate the source: http://blog.csdn.net/xd43100678/archive/2009/11/05/4769733.aspx