title: update a cell in a excel sheet using powershell
body: <p>I need to search for a word in a row from a spreadsheet and update another cell in the same row with a different value. For example, I have the data like this. I need to search for the person "Smith" from the below spreadsheet and update the value of the 'Status' column from 'Enabled' to 'Disabled' for that row.</p>
  
  <pre><code>"Region","Zone","Customer","Process","Status"
  "TEST","East","Smith","HR","Disabled"
  "TEST","East","Allen","Finance","Enabled"
  "TEST","East","Jake","Payroll","Enabled"
  </code></pre>
  
  <p>I tried regex and few other functions before posting the question. But I can't get them to work. </p>
  
  <p>Thanks.</p>