title: Deleting an entire row in Excel using PowerShell
body: <p>I need a code the deletes the first row in a CSV file (the row is also empty).  I am using the code below to get the CSV file I need and delete tne content in the first cell, which is "users". But when I delete the content the cell remains empty. What I need is either a way to delete the whole row or maybe shift the entire column up after deleting "users"? Don't know if that works...</p>
  
  <pre><code>Get-Content C:\TEMP\test\File1.csv |
      % { $_ -replace 'users', '' } |
      Set-Content C:\TEMP\test\file2.csv
  </code></pre>