Description of environment and exception information
Environment Note: Win2008 R2 Enterprise Edition x64, IIS 7.0
Function Description: Server-side operations Excel, (upload Excel to the server, and read data from Excel on the servers)
Exception information: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-c000-000000000046} failed due to the FO Llowing error:80070005 denied access. (Exception from hresult:0x80070005 (e_accessdenied)).
Processing process
1. The server side must have Office Excel software installed;
2. "Start"--"Run"--enter "DCOMCNFG"--"OK" to open the Component Services window
3. "Component Services"--"computer"--"My Computer"--"DCOM Config"--"Microsoft Excel Application" (x64 for system need to configure according to the following method)
If you cannot find Microsoft Excel application, refer to the following methods:
① "Start"--"Run"--enter "mmc-32"--"OK" to open the "console" window;
② Select "File"-"Add/Remove Snap-in"-Select "Component Services" in "available snap-in"-click "Add"-"OK";
4. Right---"Properties"--"security", "Launch and activation Rights", "Access rights", "Configure Permissions" select "Custom", three add "Iis_iusrs" user, tick 1, "Local access" "Local Activation" 2, "local access" 3, "read" Other recommendations are not checked for safety reasons.
5. Select "Interactive User" in the "Identification" tab
6. All settings are self-tested without restarting. If there is a denial of access, etc., in the 4th step, check all the permissions, and add "NETWORK SERVICE", "ASPNET" (Server 2003, XP system) users, the 5th step to try to use the other two kinds of accounts.
Retrieving the COM class factory for component and CLSID XX failed due to the following error:80070005 denied access.