• 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

  • 相关阅读:
    json
    [题解]luogu_P2151_HH去散步(矩阵floyd
    [题解]数字计数(数位dp(模板向
    【简单计数知识】JZOJ6395. 【NOIP2019模拟2019.10.28】消失的序列
    字符云例子
    JAVA FileUtils(文件读写以及操作工具类)
    AT2657 Mole and Abandoned Mine
    Problem: [Usaco2018 Open]Team Tic Tac Toe
    Problem: [USACO2018 Jan]Blocked Billboard II
    算法——星星树
  • 原文地址:https://www.cnblogs.com/LcVong/p/12438807.html
Copyright © 2020-2023  润新知