My PC is Windows 10.Unable to cast COM object of type 'System.__Comobject' to interface type 'Microsoft.Office.Core.IRibbonUI'. This operation failed because the QueryInterface call on the COM component for the interface with the ID '{000C03A7-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
Excel SQLlite Library not registered
-
- Posts: 2
- Joined: Wed 24 May 2017 16:14
Excel SQLlite Library not registered
I just installed the trial of the Excel Add-in for SQLlite. It looked like it was going to work "right out of the box." As soon as I pointed to the DB file the add-in saw all the tables. But when I try to import the data I get
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Excel SQLlite Library not registered
The reason of this error is that Microsoft Office is not properly installed or its previous version is not uninstalled correctly on this computer. It is not caused by our Excel Add-in.
For example, the following solution can be of help for you: http://stackoverflow.com/questions/26250437/
This solution is supposed for the same issue. Reasons are the same for both issues.
1.7 - for Excel 2010, 1.8 - for Excel 2013, 1.9 - for Excel 2016.
The stackoverflow example has an error with different IID value. In your case you need to perform a search by another IID: {000C03A7-0000-0000-C000-000000000046}. In your post you specify {000C03A7-0000-C000-000000000046}, but looks like it's a mistake and you miss "0000-", and you should search the {000C03A7-0000-0000-C000-000000000046} IID.
If there are several subkeys in HKEY_CLASSES_ROOT\TypeLib{000C03A7-0000-0000-C000-000000000046}\, delete everything except the one that corresponds to your Excel version.
I.e. you need to perform the following actions:
1. Open the Registry Editor, select HKEY_CLASSES_ROOT and begin search of value 000C03A7-0000-0000-C000-000000000046
2. The found key has a subkey TypeLib. Select it and remember the Version entry value. Additionally copy a value of the Default entry.
3. Go to HKEY_CLASSES_ROOT\TypeLib\ and search for the copied value of the Default entry.
The found key has several subkeys. One of them will be equal to the value of the Version entry found on the step 2. You need to delete all the subkeys except this one.
This should fix the issue. If the same error occurs for a different IID value after this, you will need to repeat these steps for this new IID.
If this fix does not help you, try reinstalling Microsoft Excel.
Please post here about the results.
For example, the following solution can be of help for you: http://stackoverflow.com/questions/26250437/
This solution is supposed for the same issue. Reasons are the same for both issues.
1.7 - for Excel 2010, 1.8 - for Excel 2013, 1.9 - for Excel 2016.
The stackoverflow example has an error with different IID value. In your case you need to perform a search by another IID: {000C03A7-0000-0000-C000-000000000046}. In your post you specify {000C03A7-0000-C000-000000000046}, but looks like it's a mistake and you miss "0000-", and you should search the {000C03A7-0000-0000-C000-000000000046} IID.
If there are several subkeys in HKEY_CLASSES_ROOT\TypeLib{000C03A7-0000-0000-C000-000000000046}\, delete everything except the one that corresponds to your Excel version.
I.e. you need to perform the following actions:
1. Open the Registry Editor, select HKEY_CLASSES_ROOT and begin search of value 000C03A7-0000-0000-C000-000000000046
2. The found key has a subkey TypeLib. Select it and remember the Version entry value. Additionally copy a value of the Default entry.
3. Go to HKEY_CLASSES_ROOT\TypeLib\ and search for the copied value of the Default entry.
The found key has several subkeys. One of them will be equal to the value of the Version entry found on the step 2. You need to delete all the subkeys except this one.
This should fix the issue. If the same error occurs for a different IID value after this, you will need to repeat these steps for this new IID.
If this fix does not help you, try reinstalling Microsoft Excel.
Please post here about the results.
-
- Posts: 2
- Joined: Wed 24 May 2017 16:14
Re: Excel SQLlite Library not registered
Wow, that was complicated, but it worked perfectly. I deleted the two extra version entries and now the Devart add-in works great. Thanks for the super-quick and expert help!