Use Excel in Azure App Service or web app | The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Excel in Azure App Service or web app

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Issue:

·       How can I use Excel in Azure app service?

·       The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

·       Error while uploading excel through Application?

·       I am getting error when using excel in Azure app service.

Solution:

Using excel in web application is very common but many users reported that it is not working in Azure app service while working fine in local.

Sometimes they see below error message,

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Please note,

'Microsoft.Ace.OLEDB.12.0' provider is not available in Azure App Services. As the App Services environment is a PaaS offering of azure, there is no way you can install drivers.

This feedback has already been shared but Azure could not implement this due to some technical restriction.

https://feedback.azure.com/forums/169385-web-apps/suggestions/17377891-oledb

You should be aware about Azure web app Sandbox where all azure web app runs.

This will clear the concept why it is not supported and why can’t you install it in web app

https://github.com/projectkudu/kudu/wiki/Azure-Web-App-sandbox

I found one solution to use excel in azure app service.

You can implement this through OpenXML SDK.  

https://www.microsoft.com/en-us/download/details.aspx?id=5124

You just need to download it and write your code.

https://docs.microsoft.com/en-us/office/open-xml/how-to-parse-and-read-a-large-spreadsheet

I have used it web app and now I am able to perform all excel operation successfully.

I hope this helps. Please share your query/feedback

Similarly, if you can refer below URL if you want to use PDF like IronPDF in Azure App service

https://www.server.hoit.asia/2019/12/use-pdf-in-azure-app-service-e.html

Other useful references,

Issue: Azure Functions: The Consumption pricing tier is not allowed in this resource group Solution : https://www.server.hoit.asia/2019/07/azure-functions-consumption-pricing.html

Issue: Azure function is throwing one of the following exception ·       Unable to retrieve Functions Keys ·       We are not able to retrieve the keys for function ·       The function runtime is unable to start. ·       Function host is not running. ·       Internal Server error. ·       Service Unavailable. Solution : https://www.server.hoit.asia/2019/07/azure-functions-unable-to-retrieve.html

Issue: Disable Azure functions https://www.server.hoit.asia/2019/07/how-to-disable-functions-in-azure.html