CODEWITHSUNDEEP
excelpowershellexport
runcmd
runcmd

Reputation: 602

Exporting powershell results to excel

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.

Upvotes: 0

Views: 432

Answers (1)

Tim Ferrill
Tim Ferrill

Reputation: 1674

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

Upvotes: 1

Related Questions