Question

1
Replies
1167
Views
Close popover
Mathavakrishnan Kannan (MathavakrishnanK)
Incessant
Pega Manager
Incessant
GB
MathavakrishnanK Member since 2014 3 posts
Incessant
Posted: October 12, 2017
Last activity: November 6, 2018
Closed

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.

Robotic Process Automation
Moderation Team has archived post,
Close popover 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.