read a specific cell of excel sheet using asp.net

Question

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

Dhirendra Misra · Answer

Hello Saifullah 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 string temp = (string)(xlRange.Cells[i j] as Excel.Range).Value2; MessageBox.Show(temp); T hanks