Question

1
Replies
78
Views
VijayV54 Member since 2017 2 posts
Cigna Corporation
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed
Solved

Microsoft Excel 2010

Hi,

I'am trying to import an excel into my Pega Robotic studio. Below are steps I performed,

1. An automation was created; under Toolbox-> Connectors-> Choose Items-> Pega Robotic Static members-> From Directory Location, selected the OpenSpan.Office.dll from the path: C:\Program Files (x86)\OpenSpan\OpenSpan Studio for Microsoft Visual Studio 2015\Office2013. Also pasted the dll in the connectors. The Microsoft components were listed (excel, words, outlook, etc.,)

2. Added this excel component in my automation, under properties-> Workbook, gave the path of the excel from my machine(tried both .xlsx, .xlsm).

I get a warning window which shows, "Property value is not valid". The details button shows "Microsoft Excel 2010 is not present."

Note: During installation, I did not choose any office product as I have 2013 already installed in machine. I could see the same issue, when I tried to import the dll from Office2010 (step 1)

Please advise on how to proceed?

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