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

 Dilip Kumar Nagaraj (DilipKumarN)
Accenture
Dilip Kumar Nagaraj
Accenture
GB
DilipKumarN Member since 2013 13 posts
Accenture
Posted: Jun 29, 2018
Last activity: Oct 9, 2018
Posted: 29 Jun 2018 2:37 EDT
Last activity: 9 Oct 2018 10:19 EDT
Closed

Parse excel file with cell value referencing from other cell

Hi All,

We have a requirement to parse an excel file which contains reference cell value.

We follow OOTB method by using an excel template and the activity MSOParseExcelFile . Parsing the direct values from cell works fine. But with this syntax {.PageListName().PropertyName input} not able to parse cell with reference value (e.g:Column:Cost; =Sheet2!D5).

I have attached both the excel template and actual excel file to be uploaded for reference.

Appreciate any help

***Updated by moderator: Lochan to update platform capability***

To see attachments, please log in.
Low-Code App Development
Reporting
User Experience

Posted: 6 years ago
Posted: 29 Jun 2018 3:14 EDT
Dilip Kumar Nagaraj (DilipKumarN)
Accenture
Dilip Kumar Nagaraj
Accenture
GB

Hi Arun,

In the link you refered, the specified syntax is {.pxResults().pyUseridentifier input} which will work for direct values in cell.But not for reference values.I'm looking to parse reference value as specified in my post

Thanks,

Show More

Hi Arun,

In the link you refered, the specified syntax is {.pxResults().pyUseridentifier input} which will work for direct values in cell.But not for reference values.I'm looking to parse reference value as specified in my post

Thanks,

Dilip

 

Show Less
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