I'm looking for a code snippet to do the following, I've created a bit of the code:
1. Read a list certificates - $certs gci c:\certs -include *.pfx -name
2. For each certificate name run the following command against it
openssl pkcs12 -in <certificate name.pfx> -out <certificate name.pem> -nodes -password pass:<Password>
3. The password has to be extracted from an excel spreadsheet with two columns, certificate name and password.
I essentially want to be able to convert a load of pfx certs to pem certs and retrieve the associated passwords from a spreadsheet, the certificate name in the spreadsheet will be identical to the one in step 1
Any help appreciated.