111,129
社区成员
发帖
与我相关
我的任务
分享
const string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;"
+ "Data Source=C:\\test.xlsx;Extended Properties=Excel 12.0;";
using (var oledb = new System.Data.OleDb.OleDbConnection(connectionString))
{
var cmd = oledb.CreateCommand();
cmd.CommandText = "select * from [Sheet1$]";
oledb.Open();
var reader = cmd.ExecuteReader();
//...
oledb.Close();
}