title: Extract Values from Rows in Excel using powershell
body: <p>I am novice to powershell.
  I have an excel sheet with certain inputs, My excel sheet looks like </p>
  
  <pre><code>[excel][1]
  
  $filepath="Path to file.xlsx"
  $objExcel = New-Object -ComObject Excel.Application 
  $objExcel.Visible = $false
  $objExcel.DisplayAlerts = $false
  $WorkBook = $objExcel.Workbooks.Open($FilePath)
  $WorkSheet = $WorkBook.sheets.item("sheet1")
  $tooluse=Read-Host "Please Enter the tool"
  
  for($i=2;$i -lt 8;$i++)
   {
       $op=$Worksheet.Rows.Item($i).Columns.Item(1).Text
       if ( $op -eq $tooluse )
       {
           return $tooluse
       }
  }
  </code></pre>
  
  <p>I want my powershell script to print for input "java" .
  1.6 sun</p>