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

 Uday Shankar NeelapaReddy (Uday Shankar N)
Wells Fargo
Developer
Wells Fargo
IN
Uday Shankar N Member since 2016 3 posts
Wells Fargo
Posted: Mar 1, 2019
Last activity: Mar 2, 2019
Posted: 1 Mar 2019 1:02 EST
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

To see attachments, please log in.
Java and Activities

Posted: 5 years ago
Posted: 1 Mar 2019 3:27 EST
Mounica Gudaboina (gudam)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

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!

To see attachments, please log in.
Posted: 5 years ago
Posted: 2 Mar 2019 23:53 EST
Chandrasekhar Gollamudi VN (chandrasekhar_g)
PEGA
Senior Manager, Technical Support - Runtime Engine and Search
Pegasystems Inc.
IN

Hi Uday,

Addition to above provided information, below article can be seen regarding  MSOParseExcelFile activity

https://community.pega.com/knowledgebase/articles/configuring-application-bulk-upload-data-using-excel-spreadsheet

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