i have an excel sheet i want to read a cell from that sheet which has no heading just have the values using asp.net.
can somebody please tell me how to do it.
thanks in advance
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Dhirendra MisraPosted Jan 7, 2014, 12:04 AM
First you need to add a reference in your project to Excel Objects Library. The excel object library can be added in the COM tab of adding reference dialog.
You need to get range object to read the cell.
Refer the following links
http://social.msdn.microsoft.com/Forums/vstudio/en-US/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380/reading-excel-from-c?forum=vsto
http://stackoverflow.com/questions/15873389/reading-data-from-excel-2010-using-microsoft-office-interop-excel
From above link
Thanks