C#

for(rCount...){
  for(cCount...){
       str.Add(range.Cells[rCount, cCount].Value2.ToString());
  }
}

private void importDataFromExcelToolStripMenuItem_Click(object sender, EventArgs e)
 {
     /*****************************************************************************
      * allows to read file from excel
      * reference: http://csharp.net-informations.com/excel/csharp-read-excel.htm
      * ******************************************************************************/
     OpenExcelFile.Title = "SELECT EXCEL FILE TO IMPORT FROM ";
     OpenExcelFile.Filter = "XLS FILES|*.XLS";
     OpenExcelFile.InitialDirectory = @"c:\";
     string filepath = null;
     if (OpenExcelFile.ShowDialog() == DialogResult.OK)
     {
         filepath = OpenExcelFile.FileName;
     }


     Excel.Application xlApp;
     Excel.Workbook xlWorkBook;
     Excel.Worksheet xlWorkSheet;
     Excel.Range range;

     xlApp = new Excel.ApplicationClass();
     xlWorkBook = xlApp.Workbooks.Open(filepath, 0, true, 5, "", "", true,
                                        Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t",
                                        false, false, 0, true, 1, 0);
     xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);


     List<string> strList= new List<string>();
     string str;
     int rCount = 0;//row counter
     int cCount = 0;//column counter

     range = xlWorkSheet.UsedRange;

     for (rCount = 1; rCount <= range.Rows.Count; rCount++)
     {
         for (cCount = 1; cCount <= range.Columns.Count; cCount++)
         {
             str = (string)(range.Cells[rCount, cCount] as Excel.Range).Value2;
             strList.Add(str);

         }
     }

     xlWorkBook.Close(true, null, null);
     xlApp.Quit();

     releaseObject(xlWorkSheet);
     releaseObject(xlWorkBook);
     releaseObject(xlApp);

 }

 private void releaseObject(object obj)
 {
     try
     {
         System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
         obj = null;
     }
     catch (Exception ex)
     {
         obj = null;
         MessageBox.Show("Unable to release the Object " + ex.ToString());
     }
     finally
     {
         GC.Collect();
     }
 }

public class Something{
     public string Name{get;set;}
     public string Surname{get;set;}
     .
     .
     .
}

for(RCount...{
    curr = new Something();
    for(cCount...){
        if(c==1){
             curr.Name = (string)(range.Cells[rCount, cCount] as Excel.Range).Value2;
        }
        if(c==2){
        ...
        }
        .
        .
    }
    //now(outside the column for) add it to the list of something
    lst.Add(curr);
}

//the actual connection
                string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" + yourFileNameHere+ ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\";";
                OleDbConnection con = null;
                lst = new List<Something>();
                Something curr = new Something();

                con = new OleDbConnection(connString);
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = con;
                cmd.CommandText = "SELECT Name,SurName,etc.. " +
                    "FROM [Sheet1$]";

                OleDbDataReader dr = null;
                try
                {
                    con.Open();
                    dr = cmd.ExecuteReader();

                    while (dr.Read())
                    {
                        curr = new Something();
                        curr.Name = dr.IsDBNull(0) ? "Empty" : dr.GetString(0);
                        curr.SurName = dr.IsDBNull(1) ? "Empty" : dr.GetString(1);
                        .
                        .
                        if (curr.IsOK())//this is really usefull
                        {
                           lst.Add(curr); 
                        }
                    }                    
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    //posible log and stuff
                }
                finally
                {                    
                    if (con.State != ConnectionState.Closed)
                    {
                        con.Close();
                    }
                    con.Dispose();
                    con = null;
                }

var needed = from rec in lst
     where rec.Name=="YourName"
     select whateverYouNeed;

mbangh wrote:

I have a listview control