c#读取excel的xls和xlsx文件的方法

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

jack_london2

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

阅读量1.7k

点赞数 1

分类专栏： C#

原文链接：https://blog.csdn.net/orichisonic/article/details/50203047

版权

C# 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

public static DataTable GetExcelToDataTableBySheet(string FileFullPath,string SheetName)
{
//string strConn = “Provider=Microsoft.Jet.OleDb.4.0;” + “data source=” + FileFullPath + “;Extended Properties=‘Excel 8.0; HDR=NO; IMEX=1’”; //此连接只能操作Excel2007之前(.xls)文件
string strConn = “Provider=Microsoft.Ace.OleDb.12.0;” +“data source=” + FileFullPath + “;Extended Properties=‘Excel 12.0; HDR=NO; IMEX=1’”;//此连接可以操作.xls与.xlsx文件
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter(string.Format(“SELECT * FROM [{0}]”, SheetName), conn); //(“select * from [Sheet1$]”, conn);
odda.Fill(ds, SheetName);
conn.Close();
return ds.Tables[0];

}