Question
1
Replies
34
Views
RBC
Posted: July 23, 2018
Last activity: July 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?
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.
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.