I have requirement to write a data from sql server to Existing Excel(Micron template). To achieve this I tried Microsoft office interop DLL(Microsoft.Office.Interop.Excel) , it's working on my local machine but getting the below error when we deploy that build/Code in Azure App service.
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).