Question: how to get data from excel sheet in asp.net?
Answer: Step 1: Open Visual Studio > File > New >Website > Under Templates, click ASP.NET WebSite and choose either Visual C# or Visual Basic as the language. ... 
Step 2: We will create two excel sheets and add them to the project. ... 
Step 3: We will now create a web.config file to store the connection string information.