Excel导入的Azure问题 [英] Azure issue with Excel import

问题描述

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. issue not occuring in localhost only in azure. Below is our connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Macro;HDR=YES'

我们正在尝试从Excel工作表中导入数据.使用我提供的连接字符串，可以在localhost中正常运行.但 在azure网站中，它抛出了我提到的错误.这需要在Azure服务器中设置

We are trying to import data from Excel sheet. This goes through fine in localhost using the connection string I provided. But in azure website it is throwing the error that I mentioned. This needs to be setup in the azure server

推荐答案

线程1 和

The Microsoft.Ace drivers are not installed on Azure App Service.  You may refer these discussion threads (thread1 and thread2) for different approaches.

这篇关于Excel导入的Azure问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！