I have an excel sheet that I'm trying to pull the employee ID from the first column but I'm getting the error "You cannot call a method on a null-valued expression" which I assume means its not reading the value within excel.

# First-time setup, install the module:

Install-Module ImportExcel

Import the module:

Import-Module ImportExcel

Now, import the data from your existing excel document:

$wb = Import-Excel -Path 'c:\Scripts\Emp.xlsx'

Display the data by using the column names:

$ws=$wb.ActiveSheet

$Row=3 do { $data.Range("A$Row").Text if ($data) { Write-Verbose "I see $data" $Row }

else { write-host "This is broken"}

}while($Row -ne 221)