Azure 'Microsoft.ACE.OLEDB.12.0' 提供程序未在本地计算机上注册

Question

我在使用 Azure 时遇到问题，想要处理 Excel 文件，但收到错误“‘Microsoft.ACE.OLEDB.12.0’提供程序未在本地计算机上注册。”。

我在我的电脑中安装了 AccessDataBaseEngine 2007，但收到了相同的错误消息。

我能做什么？

Answer 1

If you only need to work with Excel 2007 formats or later (xlsx), you can use the OpenXml SDK. This SDK requires installation on your local machine. But you can simply reference the DocumentFormat.OpenXml.dll assembly in your Web/Worker Role, and set Copy Local to true. It will work in the cloud. It also doesn't require Office to be installed on the cloud machine.

欲了解更多信息，请查看Error on only Azure - 'Microsoft.ACE.OleDb.12.0' provider is not registered on the local machine和 The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

希望这对您有帮助。