title: Insert an empty row in an Excel document using PowerShell
body: <p>I am trying to programmatically insert a new row at a specified place in my Excel sheet, and despite extensive searching around the web I was unable to find a way to achieve this.</p>
  
  <p>The following code successfully inserts an empty column:</p>
  
  <pre><code>$xlShiftToRight = -4161
  
  #Get list of files
  $File = Get-ChildItem c:\path\to\file.xlsx
  
  #Launch Excel
  $XL = New-Object -ComObject Excel.Application
  
  #Open the file and get the Data sheet
  $WB = $XL.Workbooks.Open($File.Fullname)
  
  $XL.Visible = $true
  $Sheet = $WB.Worksheets.Item('Naira')
  
  $objRange = $XL.Range("C3").EntireColumn
  [void]$objRange.Insert($xlShiftToRight)
  </code></pre>
  
  <p>But the specular alternative - using <code>EntireRow</code> instead of <code>EntireColumn</code> does not.</p>
  
  <p><strong>QUESTION</strong></p>
  
  <p>How do I <em>insert</em> a row at after another specific row in an Excel document using PowerShell?</p>