public class Data
{
public int Col1 { get; set; }
public string Col2 { get; set; }
public string Col3 { get; set; }
}//excel文件路径
var filePath = "z:\\1.xls";
var lst = new List();
//创建ole连接
using (var con = new System.Data.OleDb.OleDbConnection($"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={filePath}; Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"))
{
//打开连接
con.Open();
//创建命令对象
var cmd = con.CreateCommand();
//设置查询语句
cmd.CommandText = " SELECT [列1],[列2],[列3] FROM [表名$] ";
//执行查询,并获取reader对象
using (var reader = cmd.ExecuteReader())
{
//循环读取所有数据
while (reader.Read())
{
//获取数据并加入lst中
lst.Add(new Data
{
Col1 = (int)reader["列1"],
Col2 = reader["列2"].ToString(),
Col3 = reader["列3"].ToString(),
});
}
}
}
//转化为数组
var arr = lst.ToArray();
//.......