Exporting powershell results to excel

Question

Get-HPiLOFirmwareVersion -Server $Server -Username $username
                         -Password $password | Select-Object IP |

I'm struggling trying to figure out what/where to pipe my results to in order to create/modify an excel document.

Server and IP are my headers. Then I want to fill in with the results from the command.

Tim Ferrill · Accepted Answer · 2014-05-21 16:04:44Z

1

Piping to Export-CSV is your best option. You can create a native Excel file using PowerShell and .Net, but it's much more cumbersome.

If you have to create/edit an Excel document check out this link: Automating Excel with PowerShell

answered May 21, 2014 at 16:04

Tim Ferrill

1,6941 gold badge12 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1