Powershell Install-Module ImportExcel - unable to find module providers

PowerShell Help
16

You can use it in a similar way to Import-CSV whereby every row is an object.

If this is my spreadsheet:

FirstName Surname
Willow Rosenberg
Buffy Summers
Xander Harris
Tara Maclay
Joyce Summers
Rupert Giles

Let’s say I want the first name of all the people with the surname Summers.

$excelData  = Import-Excel Names.xlsx
$firstNames = $excelData | 
    Where-Object {$_.Surname -eq 'Summers'} | 
        Select-Object -ExpandProperty FirstName
$firstNames