I have a web application that reads an excel spreadsheet and imports the cell values into the database automatically. I am using COM, so it is necessary on the machine Microsoft Excel installed. When compiling locally it works without problems. However, I hosted in azure recently and the error is due to not having Excel installed. How can I work around this error? I do not understand much of the azure, so I wanted to know a way to install Microsoft Office Excel.
ERROR THAT APPEARS:
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)).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: 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)).