Question: how to read data from excel sheet using c# console application?
Answer: NET 4+ allows C# to read and manipulate Microsoft Excel files, for computers that have Excel installed (if you do not have Excel installed, see NPOI). First, add the reference to Microsoft Excel XX. X Object Library, located in the COM tab of the Reference Manager. I have given this the using alias of Excel.