/// <summary>

        /// 获取Excel数据，包含所有sheet

        /// </summary>

        /// <param name="fullPath"></param>

        /// <returns></returns>

        public DataSet GetExcelTables(string fullPath)

        {

            DataSet ds = new DataSet();

            if (File.Exists(fullPath))

            {

                //HDR=No 第一行就是数据

                string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fullPath + ";Extended Properties='Excel 12.0;HDR=No;IMEX=1;'";

                using (OleDbConnection conn = new OleDbConnection(strConn))

                {

                    conn.Open();

                    foreach (DataRow item in conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows)

                    {

                        string tableName = item[].ToString().Trim();

                        DataTable dt = new DataTable();

                        dt.TableName = tableName;

                        OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + tableName + "]", conn);

                        odda.Fill(dt);

                        ds.Tables.Add(dt);

                    }

                }

            }

            return ds;

        }