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