title: How to open excel workbook from powershell for automation
body: <p>I want to open an excel workbook and read out data, do other kinds of operations, etc.  I know that I have to add an assembly reference:</p>
  
  <pre><code> [Reflection.Assembly]::LoadFile("C:\Program Files\Microsoft Office\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin\Microsoft.Office.Interop.Excel.dll")
  </code></pre>
  
  <p>And then I need to instantiate an Application object. </p>
  
  <pre><code>$workbook = New-Object -TypeName Microsoft.Office.Interop.Excel.Application
  </code></pre>
  
  <p>This however returns an error "A constructor was not found"
  Isn't by the way Microsoft.Office.Interop.Excel.Application an interface actually? I am wondering how it can be instantiated in <a href="https://stackoverflow.com/questions/464902/how-to-open-an-excel-file-in-c">this</a> scenario.</p>