C# 简单的读取数据Excel帮助类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.OleDb;
using System.Data;

namespace ToolUtilities
{
    public class ExcelHelper
    {
        /// <summary>
        /// 链接字符串
        /// </summary>
        private  string ConnStr;

        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="path">EXCEL文件路径</param>
        public ExcelHelper(string path)
        {
            if (!string.IsNullOrEmpty(path))
            {
                ConnStr = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';", path);
            }
            else
            {
                ConnStr = ConfigurationManager.ConnectionStrings["excel"].ConnectionString;
            }
        }

        /// <summary>
        /// 读取Excel文件的内容
        /// </summary>
        public  DataSet Query(string sql)
        {
            DataSet ds = new DataSet();
            try
            {
                using (OleDbConnection conn = new OleDbConnection(ConnStr))
                {
                    using (OleDbCommand cmd = new OleDbCommand(sql, conn))
                    {
                        using (OleDbDataAdapter oda = new OleDbDataAdapter(cmd))
                        {
                            oda.Fill(ds);
                        }
                    }
                }
            }
            catch (System.Exception ex)
            {
                throw new Exception(ex.Message);
            }

            return ds;
        }
    }
}