Posted: 1 Mar 2019 1:02 EST Last activity: 2 Mar 2019 23:53 EST
Parsing Excel Sheet using MSOParseExcelFile extracts formula along with cell data
We are facing problem parsing Excel Sheet using MSOParseExcel control. It extracts formula along with cell data. We follow OOTB method by using an excel template and the activity MSOParseExcelFile. The value of the cells which we read are actually populated based on a formula from a different sheet. After parsing. the clipboard properties contains the formula appended with the cell value instead of cell value alone.
Also MSOParseExcelFile is Final Internal rule. Anyone other than PegaRULES is not supposed to use it. Further this has been deprecated in 8.1. Hence, it is suggested to upgrade to 8.1.X version and use below activity :
pxParseExcelFile of @baseclass of Pega-AppDefinition:08-01-01