AlexµÄ²©¿Í

/// <summary>
        /// °ÑExcel2003µÄÎļþÊý¾Ý¶ÁÈëdataset·µ»ØÊý¾Ý¼¯
        /// </summary>
        /// <param name="filepath">excelÎļþ·¾¶</param>
        /// <returns></returns>
        public DataSet Xsldata2003(string filepath)
        {
            DataSet ds = new DataSet();
            string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;IMEX=1'";
            using (System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon))
            {
                Conn.Open();
                DataTable tblSchema = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                foreach (DataRow dr in tblSchema.Rows)
                {
                    string tblname = dr["TABLE_NAME"].ToString();
                    string strCom = "SELECT * FROM [" + tblname + "]";
                    System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
                    myCommand.Fill(ds, tblname.Substring(0, tblname.Length - 1));
                }
            }
            return ds;
        }