excel操作 荣

 string path = @"F:\Documents and Settings\Administrator\My Documents\sql.xls";
            OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;data source=" + path);
            OleDbDataAdapter dapter = new OleDbDataAdapter("SELECT * FROM [SQL$]", conn);
            DataTable dt = new DataTable();
            dapter.Fill(dt);
            int rows = dt.Rows.Count;
            PositionBN bn = new PositionBN();
            for (int i = 0; i < rows; i++)
            {
                bn.Execute(dt.Rows[i][0].ToString());
            }