how to read the data from excel

Question

how to read the data from excel? in my task excel sheet is uploaded to web application and the i want to read the values i want to display in textboxs. please give me an idea.........

Jaish Mathews · Answer

Attached a sample code to read excel. Excel file can see in side Debug folder.

manohar vakkala · Answer

please it elobrately

Jaish Mathews · Answer

Hi Use builtin OLEDB class fo read/write excel sheets. They supporting SQL queries like CREATESELECT etc..Below one simple article saying that how we can use OLEDB. There used CREATE query for creating a new excel sheet but you can replace it with SELECT query. http://www.c-sharpcorner.com/UploadFile/jaishmathews/861/?ArticleID=7b90e584-a5d5-4f02-a196-ea113f310d81