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

今天药忘吃喽~ 2022-12-30 13:56 626阅读 0赞

Excel导入时报此错误：“System.InvalidOperationException:“未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序。”。

只需要下载安装：AccessDatabaseEngine插件即可解决问题

下载链接如下：[https://download.csdn.net/download/qq\_37192571/13786918][https_download.csdn.net_download_qq_37192571_13786918]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MTkyNTcx_size_16_color_FFFFFF_t_70][]

public DataTable GetData(string Path)     //读取方法
            {
                string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 12.0;";
                string strExcel = "select * from [Formula$]";
                OleDbConnection ole = new OleDbConnection(strConn);
                ole.Open();
                DataTable schemaTable = new DataTable();
                OleDbDataAdapter odp = new OleDbDataAdapter(strExcel, strConn);
                odp.Fill(schemaTable);
                ole.Close();
                return schemaTable;
            }

[https_download.csdn.net_download_qq_37192571_13786918]: https://download.csdn.net/download/qq_37192571/13786918
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MTkyNTcx_size_16_color_FFFFFF_t_70]: /images/20221120/3b27e036a4024807969a96b9a0bb8521.png