C# 读取Excel文件

最新推荐文章于 2024-07-09 10:27:57 发布

web前端-白小白

最新推荐文章于 2024-07-09 10:27:57 发布

阅读量513

点赞数

分类专栏： C# 文章标签： C# Excel

本文链接：https://blog.csdn.net/zz3hh/article/details/9232385

版权

C# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

public DataTable getDataTableFormExcelXlsx(string filePath,string tableName)
        {
            if (filePath.Trim().Length > 0)
            {
                string stro = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data source=" + filePath + ";" + "Extended Properties=Excel 8.0";
                string str1o = string.Format("SELECT * FROM [{0}$]", tableName);
                try
                {
                    OleDbConnection oco = new OleDbConnection(stro);
                    oco.Open();
                    OleDbDataAdapter odao = new OleDbDataAdapter(str1o, oco);
                    DataTable  resultTable= new DataTable();
                    odao.Fill(resultTable);
                    oco.Close();
                    return resultTable;
                }
                catch (Exception ex)
                {
                    return null;
                }
            }
            return null;
        }

public DataTable getDataTableFormExcelXlsxSql(string filePath, string strSql)
        {
            if (filePath.Trim().Length > 0)
            {
                string stro = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data source=" + filePath + ";" + "Extended Properties=Excel 8.0";
                try
                {
                    OleDbConnection oco = new OleDbConnection(stro);
                    oco.Open();
                    OleDbDataAdapter odao = new OleDbDataAdapter(strSql, oco);
                    DataTable resultTable = new DataTable();
                    odao.Fill(resultTable);
                    oco.Close();
                    return resultTable;
                }
                catch (Exception ex)
                {
                    return null;
                }
            }
            return null;
        }