title: How do I convert data using powershell and then grab the users I want
body: <p>How do I create a variable to store  data for further manipulation and then Convert the data coming out of the Excel document into a PSCustomObject and then filter it down to the people I care about </p>
  
  <p>Here's what I have so far:</p>
  
  <pre><code>$excel = new-object -comobject Excel.Application
  $path = "C:\Users\Test.xlsx"
  $excel.workbooks.open($path)
  $excel.Visible = $True
  
  $variable = $excel.workbooks.open($path)
  $worksheet = $variable.activeSheet
  
  
  For ($j = 6; $j -lt 124; $j++) {
      For ($i = 1; $i -lt 11; $i++) {
       $worksheet.Cells.Item($j,$i).text
      }   
  }
  </code></pre>