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