class Import

    {

        /// <summary>

        /// 导入Excel到DataSet中

        /// </summary>

        /// <param name="strFileSourse">文件的路径和文件全名，含扩展名</param>

        /// <returns></returns>

        public DataSet ExcelToDataSet(string strFileSourse)

        {

            DataSet ds = new DataSet();

            //Excel数据源（兼容03/10）

            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileSourse + ";Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1\"";

            //连接

            OleDbConnection conn = new OleDbConnection(strConn);

            try

            {

                conn.Open();

                //获取Excel中所有的sheet

                DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

                //把Excel中所有的sheet数据读到一个Table中

                for (int i = ; i < dtSheet.Rows.Count; i++)

                {

                    string strSheetName = dtSheet.Rows[i]["TABLE_NAME"].ToString();

                    OleDbDataAdapter OleDa = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn);

                    OleDa.Fill(ds, "TableName");

                    conn.Close();

                }

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

            finally

            {

                if (conn.State != ConnectionState.Closed)

                {

                    conn.Close();

                }

            }

            return ds;

        }

    }