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

 ashwini nandanavanam (ashwinin2214)
RBC

RBC
CA
ashwinin2214 Member since 2018 5 posts
RBC
Posted: Jul 23, 2018
Last activity: Jul 24, 2018
Posted: 23 Jul 2018 16:11 EDT
Last activity: 24 Jul 2018 10:24 EDT
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
Posted: 24 Jul 2018 10:24 EDT
Thomas Sasnett (ThomasSasnett)
MOD
Lead Robotics Architect
Pegasystems Inc.
US

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