how to read data from excel file in c#
i create a excel file from c# with data validation-it seem like combo with choosen possibility

string mList1 = "=ProductCode";
                oRng = oSheet.get_Range("H8", "H9");
                oRng.Name = "ProductCode";
                int t = dt.Rows.Count + 2;
                string st = "F" + t;
                oRng = oSheet.get_Range("F2", st);
                oRng.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, Missing.Value, mList1, Missing.Value);

now i want to read the excel file and also the chosen item from the combo
i seccues to read all the data but the data validation

read the data-
Microsoft.Office.Interop.Excel.Application ExcelObj = null;
            ExcelObj = new Microsoft.Office.Interop.Excel.Application(); 
            Microsoft.Office.Interop.Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open("C:\\Documents and Settings\\rachelg\\My Documents\\xxx.xls"
            ,Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing);

            Microsoft.Office.Interop.Excel.Sheets sheets = theWorkbook.Worksheets;
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
            for(int x = 1; x <= 5; x++)
            {  
             string sd = ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[x, 1]).Text.ToString();
                System.Console.WriteLine(sd);//this one column
}

in diffrent column i have the data validation but i dont know to access into it
can you help me?
urgent!!!!!

how to read data from excel file in c#
===

i create a excel file from c# with data validation-it seem like combo with choosen possibility

string mList1 = "=ProductCode";
                oRng = oSheet.get_Range("H8", "H9");
                oRng.Name = "ProductCode";
                int t = dt.Rows.Count + 2;
                string st = "F" + t;
                oRng = oSheet.get_Range("F2", st);
                oRng.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, Missing.Value, mList1, Missing.Value);

now i want to read the excel file and also the chosen item from the combo
i seccues to read all the data but the data validation

read the data-
Microsoft.Office.Interop.Excel.Application ExcelObj = null;
            ExcelObj = new Microsoft.Office.Interop.Excel.Application(); 
            Microsoft.Office.Interop.Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open("C:\\Documents and Settings\\rachelg\\My Documents\\xxx.xls"
            ,Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing);

            Microsoft.Office.Interop.Excel.Sheets sheets = theWorkbook.Worksheets;
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
            for(int x = 1; x <= 5; x++)
            {  
             string sd = ((Microsoft.Office.Interop.Excel.Range)worksheet.Cells[x, 1]).Text.ToString();
                System.Console.WriteLine(sd);//this one column
}

in diffrent column i have the data validation but i dont know to access into it
can you help me?
urgent!!!!!
