Question
Wells Fargo
Wells Fargo
IN
Wells Fargo
Posted: Mar 1, 2019
Last activity: Mar 2, 2019
Last activity: 2 Mar 2019 23:53 EST
Closed
Parsing Excel Sheet using MSOParseExcelFile extracts formula along with cell data
Hello ,
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.
Any help will be greatly appreciated.
Regards
Uday
Posted: 6 years ago
PEGA
Pegasystems Inc.
IN
Posted: 6 years ago
PEGA
Pegasystems Inc.
IN
Hi Uday,
Addition to above provided information, below article can be seen regarding MSOParseExcelFile activity
Hi Uday,
We have a hotfix for this in Pega 7.3.1.
https://community.pega.com/support/support-articles/msoparseexcelfile-activity-reads-cell-formula-along-value
Let us know the version of pega you are using.
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
Thanks!