读入Excel中的数据到DataSet

        public static DataSet LoadDataFromExcel(string filePath, string sheetName)
        {
            string strConn;
            strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM  [" + sheetName + "$]", strConn);
            DataSet myDataSet = new DataSet();
            try
            {
                myCommand.Fill(myDataSet);
            }
            catch (Exception err)
            {
                MessageBox.Show("数据绑定Excel失败!失败原因：" + err.Message, "提示信息",
                    MessageBoxButtons.OK, MessageBoxIcon.Information);
                return null;
            }
            return myDataSet;
        }

 

以上这段代码适用于Excel2007及2010，如果是2003，则需要吧Provider=Microsoft.ACE.OLEDB.12.0改为Provider=Microsoft.Jet.OLEDB.4.0。