<div>
Does it really need to be an Excel file? A CSV is much easier to handle.
</div>


Does it really need to be an Excel file? A CSV is much easier to handle.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm looking for a code snippet to do the following, I've created a bit of the code:<br />
<br />
1. Read a list certificates - $certs gci c:\certs -include *.pfx -name<br />
2. For each certificate name run the following command against it<br />
&nbsp; &nbsp; &nbsp;openssl pkcs12 -in &lt;certificate name.pfx&gt; -out &lt;certificate name.pem&gt; -nodes -password pass:&lt;Password&gt;<br />
3. The password has to be extracted from an excel spreadsheet with two columns, certificate name and password.<br />
<br />
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<br />
<br />
Any help appreciated.
</div>
</div>


Hi,

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.

Using Powershell to Convert PFX to PEM

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.