ShivRamB Member since 2019 47 posts
Posted: 2 years ago
Last activity: 1 year 2 months ago

Solved - Error in using Office/ Excel Components in Pega Robotics

we have seen errors in using MS-OFFICE components like EXCEL, WORD, OUTLOOK in Pega Robotics Automation

our environment is Windows 10 and MS-Office 2016.

if drag Excel component (after adding reference Microsoft.Office.Interop.Excel ) onto to Global Container and set any property , for example, set 'Workbook' property , then immediately it throws below error

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)).

we resolved this by doing Registry Edit, details are documented and attached for reference

***Moderator Edit-Vidyaranjan: Tagged Community Shared Knowledge***

Robotic Process Automation Developer Knowledge Share
Share this page LinkedIn