C# 根据文件路径和sheet名称读取Excel

最新推荐文章于 2021-03-02 11:11:19 发布

weixin_30732487

最新推荐文章于 2021-03-02 11:11:19 发布

阅读量233

点赞数

原文链接：http://www.cnblogs.com/alina-he/p/3768052.html

版权

public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)
        {
            //源的定义
            //string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 12.0;HDR=YES;IMEX=1';";
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";
            //;

            //Sql语句
            //string strExcel = string.Format("select * from [{0}$]", strSheetName); 这是一种方法
            string strExcel = "select * from   [" + strSheetName + "$]";

            //定义存放的数据表
            DataSet ds = new DataSet();

            //连接数据源
            OleDbConnection conn = new OleDbConnection(strConn);

            conn.Open();

            //适配到数据源
            OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
            adapter.Fill(ds, strSheetName);

            conn.Close();

            return ds.Tables[strSheetName];

        }