Hi
using Excel = Microsoft.Office.Interop.Excel;
string FilePath="..\MyFile\Demo.xlsx"; \\ path of your file
ap = new Excel.Application(); \\ creating instance of excel file
private Excel.Application ap;
private Excel.Workbook wb;
private Excel.Worksheet ws1;
rg1 = ws1.get_Range(ws1.Cells[3, 1],ws1.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell,Type.Missing)); \\getting values in range object
On google you may find more effective and simple samples.