Question
Excellus Health Plan Inc
US
Last activity: 28 Mar 2022 8:36 EDT
Parsing Excel Files - would like to get values by specific cells
The Activity: pxParseExcelFile is not parsing excel files in a way that we would like it to. We would like to extract only a particular cell's value + a few other specific cell values off of an excel spreadsheet. For example: we may need to extract only, say, B2, B3, B4, and also, say, F4, F5, F6 cell values (PFA sample excel spreadsheet) - and nothing else from a spreadsheet - and then assign these values to individual variables.
We were looking to understand, if there is any way we could achieve this specific kind of parser functionality in pega. If not with this activity, then is there any other than pxParseExcelFile activity or any other method that could get us to achieve anything similar?
Thanks in advance.