C#打开EXCEL或保存文件时报错:System.InvalidOperationException:未在本地计算机上注册” Microsoft.ACE.OLEDB.12.0"提供程序。

具体报错内容如下:

System.InvalidOperationException:未在本地计算机上注册”
Microsoft.ACE.OLEDB.12.0"提供程序。

System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionStrin
g constr, DataSourceWrapper& datasrcWrapper)
在 System.Data.OleDb.OleDbConnectionlnternal.ctor(OleDbConnectionString
constr, OleDbConnection connection)

System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOp
tions options, DbConnectionPoolKey poolKey, Object poolGroupProviderlnfo,
DbConnectionPool pool, DbConnection owningObject)

System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnection
Options options, DbConnectionPoolKey poolKey, Object poolGroupProviderlnfo
DbConnectionPool pool, DbConnection owningConnection,
DbConnectionOptions userOptions)

System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(Db
Connection owningConnection,DbConnectionPoolGroup poolGroup,
DbConnectionOptions userOptions)

System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection,TaskCompletionSource`1 retry,DbConnectionOptions
userOptions, DbConnectioninternal oldConnection, DbConnectioninternal&
connection)

System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectioninternal(DbC
onnection outerConnection,DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry,DbConnectionOptions userOptions)

System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnectio
n outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource'1 retry, DbConnectionOptions userOptions)

System.Data.ProviderBase.DbConnectioninternal.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
在 System.Data.OleDb.OleDbConnection.Open()
在Test.Testexcel.ExcelR(String filepath)位置 D:\...........

原因是:未安装office组件(accessdatabaseengine)

 下载链接:https://download.csdn.net/download/LcVong/12233688

原文地址:https://www.cnblogs.com/LcVong/p/12438807.html