We are using CA Process Automation 4.2 SP01.
Please let me know if we can access an excel file using PAM and load the details in excel to a table and if so how to do the same.
I just posted a reply to a very similar question, you can check out my reply there about using PowerShell to read in an Excel file from within CAPA.
How to read data from .xls and .xlsx file using PAM.
Retrieving data ...