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.
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
I
found one solution to use excel in azure app service.
You
can implement this through OpenXML SDK.
You just need
to download it and write your code.
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://azureappservices.blogspot.com/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
|
Issue: Azure function is throwing one of the following exception
·
We are not able to retrieve the keys for function
·
The function runtime is unable to start.
|
Issue: Disable Azure functions
|
No comments:
Post a Comment