When using MSOParseExcelFile, is it possible to specify the extraction target by Sheet name in binaryfile (Excel)?
Hello,
In binaryfile (Excel) When the order of Sheets is different in the template file and the file to be read, Is there a way to extract values by referring to the sheets whose names match?
Pega Platform 8.8.2 MSOParseExcelFile:Pega-AppDefinition:08-01-01
Example
■TemplateRFB(binary file)2 sheet exist
①"Sheet1"
Cell A1:{.propertyA1 input}
②"Sheet2"
Cell B1:{.propertyB1 input}
■FSFileName(input file)3 sheet exist
①"Sheet1"
Cell A1:"aaa1"
②"SheetXXX"
Cell B1:"XXX"
③"Sheet2"
Cell B1:"aaa2"
■Expected
propertyA1="aaa1"
propertyB1="aaa2"
■Actual
propertyA1="aaa1"
propertyB1="XXX"
Sorry for the abstract explanation, but if anyone has a better solution, I would appreciate it.