Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

1
Replies
63
Views
ashwinin2214 Member since 2018 5 posts
RBC
Posted: Jul 23, 2018
Last activity: Jul 24, 2018
Closed

Excel cell type

While reading an Excel from Pega Openspan Bot, how to determine if the cell contains plain text data or DropDown or Formula on it or any other type of field?

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago

The Excel Connector treats all cells as plain text, so with the GetCellValue method, it will always return a string representing the value of the cell. If you wish to do more with the cell, the connector is using Office.Interop and it does expose the required objects to be able to interact with it using C# code. To do what you want would require writing C# code.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice