how to get data from excel file in c#?
Select Add Reference dialogue from Project menu of your Visual Studio. Select Microsoft Excel 15.0 Object Library of COM leftside menu and click OK button. After import the reference library, we have to initialize the Excel application Object. Next step is to open the Excel file and get the specified worksheet.