問(wèn)題描述
使用 “Excel application scope” 打開(kāi) Excel 的時(shí)候 得到如下錯(cuò)誤:
“System.Exception: Error openning workbook. Make sure Excel is installed —> 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)).”
解決辦法
在注冊(cè)表中找到 Win32 和 Win64 文件夾奸鬓，刪除其中一個(gè)旦棉。當(dāng)你安裝的是 Win32 版的 Excel， 刪除 Win64 這個(gè)文件夾骤竹，以此類(lèi)推
Excel 注冊(cè)表位置：
英文原文：
We need to remove Win32 entry, if we are using Office 64-bit. Or delete Win64 entry if we are using Office 32-bit
As I read that the problem was probably in regedit, I tried to find multiple entries of office but found nothing. Instead if I looked deeper into the TypeLib-key for Excel and Outlook there was a folder named “0” and inside that folders named Win32 and Win64. The problem is that I only have a Win64-installation of office, so I changed both keys values to match my current installation of EXCEL.EXE and MSOUTL.OLB. Now UiPath finds them.
該問(wèn)題來(lái)自論壇
https://forum.uipath.com/t/error-opening-workbook-make-sure-excel-is-installed/15009
返回目錄
更多 UiPath 相關(guān)的資訊猜谚，請(qǐng)關(guān)注公眾號(hào)：流程自動(dòng)化機(jī)器人教程
由于簡(jiǎn)書(shū)禁止直接在文章中插入公眾號(hào)二維碼雕薪，請(qǐng)點(diǎn)擊 這里 了解添加該公眾號(hào)的細(xì)節(jié)曙博。
