>public void ImportData() >{ > string sCustomer = ""; > string sFile = @"C:\NSS\Excel Files\contract spares nss.xls"; > > Excel.ApplicationClass oExcel = new ApplicationClass(); > > Excel.Workbook oWorkBook = oExcel.Workbooks.Open(sFile, 0, true, 5, "", "", > true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true); > > Excel.Worksheet oSheet = (Excel.Worksheet)oWorkBook.ActiveSheet; > > for (int iRow = 0; iRow < oSheet.Rows.Count; iRow++) > { > sCustomer = oSheet.Cells[iRow, 1].ToString(); > } > >} > >>