Question

1
Replies
1119
Views
MathavakrishnanK Member since 2014 3 posts
Incessant
Posted: 2 years ago
Last activity: 2 years 11 months ago
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
Share this page LinkedIn