C#中访问Excel(xls)数据源的例程

 

static void connectToXls()
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=e:/tmp/123.Xls;Extended Properties=Excel 8.0;";
            String strSql = "select * from [sheet1$]";

            using (OleDbConnection Conn = new OleDbConnection(strConn))
            {

                OleDbCommand command = new OleDbCommand(strSql);
                command.Connection = Conn;
                
                try
                {
                    Conn.Open();
                    Console.WriteLine(Conn.ToString());

                    Object ob = command.ExecuteScalar();
                    Console.WriteLine(ob.GetType());
                    Console.WriteLine(ob);
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
                
                Conn.Close();
            }

        }