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.
But when I try to import the data I get