I need to convert a number of Excel spreadsheets to import them into a Multiterm Termbase. However, when I select "Microsoft Excel Format" as the source option, after entering the file names for input file, output file, termbase definition and log file, I get the following error:
"The conversion option could not be initialized properly. The file cannot be opened in Microsoft Excel".
To investigate further, I tried to run the same conversion using the Glossary Converter App from the SDL app store. WHen I start the app, I get the following error:
Failed to instantiate MS Excel: System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
in System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
in Microsoft.Office.Interop.Excel.ApplicationClass.get_Version()
in Sdl.MultiTerm.Tools.GlossaryConverter.Helpers.MsExcelFactory.Initialise(Boolean force)
From the above, it seems as if there is a problem with the TypeLibrary registration. So, I uninstalled Office 2016 and re-installed it. But to no avail: after reinstallation, I get the same error.
My environment is as follows:
- Windows 10 64 bit
- Office 2016 x64 16.0.4266.1001
- SDL Multiterm 2017 14.0.2184.3
Any suggestion on how to get around this issue would be welcome.
Thanks in advance