最近新写的一个项目,人脸识别需要批量导入,所以就直接查询excel 问题是我的项目是64位不能按照网上的需求修改项目属性为84位,完整代码如下
AccessDatabaseEngine x64 https://pan.baidu.com/s/1r679pOEsQkz5pvDR_TFdPA
private DataTable GetDataFromExcel(string Path)
{
string fileType = System.IO.Path.GetExtension(Path);
//连接串 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path+ ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
//返回Excel的架构,包括各个sheet表的名称,类型,创建时间和修改时间等
DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
//包含excel中表名的字符串数组
string[] strTableNames = new string[dtSheetName.Rows.Count];
for (int k = 0; k < dtSheetName.Rows.Count; k++)
{
strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
}
OleDbDataAdapter myCommand = null;
DataTable dt = new DataTable();
//从指定的表明查询数据,可先把所有表明列出来供用户选择
string strExcel = "select * from [" + strTableNames[0] + "]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new DataTable();
myCommand.Fill(dt);
return dt;
//绑定到界面
}
开始怎么也连不上就报错误 没有注册Microsoft.Jet.OLEDB.4.0;
确保你已经安装excel的情况下
后面连接字符串改成如下就可以连接成功了
string strConn = string.Format("Provider=Microsoft.ACE.OLEDB.{0}.0;Persist Security Info=False;" +
"Extended Properties=\"Excel {1}.0;HDR={2};IMEX=1;\";" +
"data source={3};",
(fileType == ".xls" ? 4 : 12), (fileType == ".xls" ? 8 : 12), (true ? "Yes" : "NO"), Path);