If you are trying use the Excel Driver provided with Microsoft Access Database Engine 2010 Redistributable Click here to download and getting following message.
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
So is it possible to have this driver on AZURE APP Service or web app?
Learn More about it https://azurefunctions.blogspot.com/2019/07/excel-in-azure-app-service-or-web-app.html
Sorry but answer is no? Click here to read the full Article
- The error is by design as we do not install the Microsoft.Ace.OLEDB.12.0‘ driver.
The Microsoft.Ace drivers are not supported in server side environments and there will be no plans to add these to the Azure Web Sites nor is it possible for you to add these.
The supportability is discussed in the following articles.
Solution
Use Open XML SDK
Information about Open XML SDK
https://docs.microsoft.com/en-us/office/open-xml/how-to-parse-and-read-a-large-spreadsheet
Free Sample code using Open XML SDK
https://www.codeproject.com/Articles/670141/Read-and-Write-Microsoft-Excel-with-Open-XML-SDK
Open XML SDK Download if required
https://www.microsoft.com/en-us/download/details.aspx?id=5124