Question

Robotics Excel Connector - File Open - Use file name from string variable

All,

I am working on a PoC, that should open a Excel File from a directory and read a column value from current active sheet. Use that value to do some calculation and set the calculated value on to another cell.

Using Excel connector, in the "Open" method, if I directly set the filename on to the "workbook" property, I am able to open the Excel workbook.

However, I wonder, is there a way to set the Open->"workbook" property value from a variable, instead of hard coding the file name on the property.

The robotics studio doesn't allow me to link a string variable value as an input to the "Open" method..

Appreciate your inputs / suggestions to work this around.

Many Thanks in advance!

I am using :

1.)

Pega Robotics Studio
Version 14.0.23107.0 D14REL
Microsoft .NET Framework
Version 4.6.01586

Installed Version: Express

Pega Robotics Studio 8.0.1039.0

2.)

Microsoft office 2016.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
October 13, 2017 - 10:00pm

Have you tried setting the ExcelWorkbook/Workbook or ExcelWorksheet/Worksheet property in the connector?