c# OleDb读取excel

最新推荐文章于 2024-03-26 21:00:00 发布

ask14k

最新推荐文章于 2024-03-26 21:00:00 发布

阅读量744

点赞数

分类专栏： XXX

本文链接：https://blog.csdn.net/luanwujian/article/details/9055791

版权

XXX 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

OleDb读取excel

using System.Data.OleDb;

//connect
OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excel路径 + ";" + 
"Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';");

//Open
objConn.Open();

//sheet name
DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);

//sql select
string strSql = "select * from [" + sheetName + "]";
OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);

// set to dataset
DataSet ds = new DataSet();
myData.Fill(ds, sheetName);

//close
objConn.Close();

//set to datatable
DataTable dt = ds.Tables[sheetName];