failed to retrieve component with CLSID {00024500-0000-0000-c000-000000000046} in COM class factory
"Retrieving a component with CLSID {00024500-0000-0000-c000-000000000046} in a COM class factory failed when exporting data to excel in the project because of the following error: 80070005", Search the Internet. The following solutions are available:
1: Install Office Excel software on the server.
2: Enter Dcomcnfg.exe in Start, run, start Component Services
3: Double-click "Computer", "Component Services", "My Computer", "DCOM Configuration"
4: Find "Microsoft Excel application" in "DCOM Config", right-click on it, then click "Properties" to pop Up "Microsoft Excel application Properties" dialog box
5: Click on the "Logo" tab and select "Interactive User"
6: Click on the "Security" tab, click "Customize" on "Launch and activation Rights", then click on the corresponding "edit" button to add the "Security" dialog box.
An "ASP." User (note to select the computer name) and give it local start and local activation permissions.
7: Remain the "Security" tab, click "Customize" on "Access", then click "Edit" and add an "ASP" user to the "Security" dialog box that appears, then give "Local access" permission.
This allows us to configure DCOM permissions for the corresponding Excel.
Note: This is configured on WinXP and on 2003, the ASP. NET user is changed to Network Service user.
Based on the above operation, the result is still this error, and then the Microsoft Office Excel Preview is configured again in the component service to resolve the problem, the configuration process is as follows:
1. In the DCOM configuration, locate the Microsoft Office Excel Preview, right-click on it, and then tap properties to pop up the Microsoft Office Excel Preview Properties dialog box
2. Click on the "Security" tab, click "Customize" on "Launch and activation Rights", then click on the corresponding "Edit" button and fill in the "Security" dialog box.
Failed to retrieve component with CLSID {00024500-0000-0000-c000-000000000046} in COM class factory