title: Which is better option OpenXml or Microsft.Office.Interop.Excel to read excel file in c#?
body: <p>I am using .NET 4.6 framework and I have to read multi sheets predefined templated excel workbook in asp.net/c# code and I know two way to solve the problem using either <strong>DocumentFormat.OpenXml.dll</strong> or <strong>Microsoft.Office.Interop.Excel.dll</strong> assembly. </p>
  
  <p>But I am in confusion which one to use as I don't have expert knowledge to decide.
  My questions are; 
  What are the pros and cons using them in a solution? 
  Is there one better than another?
  Could you please explain so that I could pick one? </p>