Vijay Vasu (VijayV54)
Cigna Corporation

Cigna Corporation
VijayV54 Member since 2017 2 posts
Cigna Corporation
Posted: March 22, 2018
Last activity: November 6, 2018
Posted: 22 Mar 2018 16:21 EDT
Last activity: 6 Nov 2018 20:02 EST

Microsoft Excel 2010


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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.