Integrating Excel and Pega Robotics Studio - Help Needed
Hi,
I'm following the instruction from this post of @jeffbadger but Pega Robotics Studio is not pulling the support for Excel 2016. I've re-installed Studio, I've added the version of Excel 2016 (which I have it as a standalone app - no office suite, just Excel) into Studio and Runtime config files, I've copied the contents of the Office2016 folder into the installation root, I've made sure the Office.Interop.Excel.dll exists, I've cleaned and rebuilt the solution and yet I am not able to get the Office objects.
Can anybody shed some light please?
See attached images
Pegasystems Inc.
US
Check the Office Version in the Runtime config and make sure that's set to 2016 as well
http://help.openspan.com/80/Platform_Configuration/RuntimeConfigXML.htm
BP3 Global Inc
US
I never got to see the Office objects described in Jeff Badger's post, however I was able to use the Excel connector to open and read an excel workbook of Excel 2016.
BP3 Global Inc
US
Still don't know why is that I can't see the Microsoft Office Excel Interop objects, and I've tried all that is documented. Would like to know more on how to enable it.
Thank you in advance.
