Question

3
Replies
168
Views
DilshanD Member since 2015 4 posts
Virtusa (pvt) Ltd
Posted: July 9, 2018
Last activity: November 6, 2018
Closed
Solved

Excel Connector Not working in Windows 10 Office 2016 Environment

Hi All,

We are trying to interact pega robotic studio with MS Excel as per advance topic "Integrating Pega and RPA". Unfortunatly We are getting an error.

Error executing link in Automation: SavetoExcel - From: Test.btnSaveTo.Click To: _SaveToExcel_GC.microsoftExcel2.Open()

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 zipped a sample solution and ran it in several workstations.
Interestingly the same solution didn't work on Windows 10 Office 16 environments(gave same error) but it worked without an issue in Windows 7 Office 13 and Windows 7 Office 16 environments.

We suspect there is something wrong with InterOp dll files with Windows 10.

We have attached sample excel automation and zip file for your reference so you can try it out your selves in Windows 10 Office 16 envirnoment.

We are using Robotics Studio 8.0.1089 build with Office 2016.
Yes there are Interop files available in Program files Openspan folder and we have selected correct office versions while installing studio.

Any help on resolving this issue is appreciated.

Robotic Process Automation SR Created
Moderation Team has archived post
Share this page LinkedIn