Question
Cognizant
IN
Last activity: 5 Mar 2020 22:18 EST
Parsing Excel file in Filelistener usnig MSOParseExcel activity
I have a requirement to read Data from an excel file using Filelistener the excel is in xlsx format i have created an activity to parse the excel and its works fine now we need to configure that activity in a file listener so that business can place the excel file in the location so that it gets parsed and stored in a data table.My issue is how can i pass the file path of to MSOParse excel activity since its a manadatary Parameter.In one of the post "https://collaborate.pega.com/discussion/upload-data-using-file-listener-combines-msoparseexcelfile" its mentioned that we have to modify the msoparseexcel activity if so kindly tell me the steps to get the absolute path.
kindly help