Enter the command in the Run bar: DCOMCNFG, open the Component Services Management window, but found that the Microsoft Excel program is missing, this is mainly a 64-bit system problem, Excel is a 32-bit component, so in the normal system component service is not visible
You can open the 32-bit component service by entering comexp.msc-32 in the run, you can see the Excel component in, I hope to help you
Programming Excel, in effect, is to invoke the COM component of Excel through the. Net Framework, all of which need to be configured when calling COM components in a WEB environment.
Many friends are reflected in the Windows environment to debug the normal program, as soon as you get to the WEB environment error, in fact, because of the lack of this step.
the configuration process for DCOM is described in detail below.
1. Run "DCOMCNFG" to open the DCOM config program. (or start → settings → control Panel → management tools → Component Services → computer → My Computer →dcom configuration)
2, find the "Microsoft Excel application" in the application list, click "Properties", under 2003 if you can't find the attribute, please hit the SP2 patch.
3. Set the authentication level in the General tab to none.
4. Select "Use custom configuration Permissions" in the "Security" tab and click "Edit".
5. Add "Internet Guest user" (usually the IUSR_ machine name) in the dialog box that opens, and the access type is set to Full control.
6. Set the user in the Identity tab to Interactive user.
7. After clicking "Apply", close the property page and DCOM Configurator. Configuration complete
How 64-bit Windows systems display 32-bit DCOM component configuration