MSOPARSEEXCELFILE is parsing the downloaded file but the latest updates made to the uploaded file are not reflected after parsing
Step by step Issue description :
#1)In our section we have a button to download a template in xlsx format .
#2)The same downloaded file ,Users modify and upload the file for processing .
#3)While processing for getting the data on clipboard we are using MSOParseExcelFile OOTB activity .
#4)When a file of 100 records are uploaded it is parsing the file and giving 100 results on the pagelist.
#5)Issue : When the same file(downloaded file) I modify few values are remove say 20 records from the template also , actually it should parse 80 results instead it is giving 100 results with the old data only.
What we have checked :
#1) We have checked the filepath and it is set with pxRequestor.pyFileUpload
whenever we try to change the name and upload it is updating properly.
#2)At the end of activity page-remove used to remove the list page .