none
Support for Excel Macros in Azure Web Application hosted in PAAS RRS feed

  • Question

  • Does Excel macros are supported in Azure Web application hosted in PAAS and Blob Storage.

    I have a requirement where input is received from a web page and needs to be passed on to the Excel stored in blob. 

    The macros should process this input and generate the output in excel. We strictly need to use excel only, no option of DB or any other processing logic.

    After going through few forums i found that Microsoft Interop Excel libraries are not supported in Azure.

    Please suggest the possible options.

    Monday, May 14, 2018 10:29 AM

Answers

  • We can't use Microsoft interop with Azure WebApp service. There is no MS Office inter-op present on Azure WebApp service and Azure WebApp is sandbox. If we want to write and read excel file on the Azure WebApp, we could use the DocumentFormat.OpenXml as workaround.

    Monday, May 14, 2018 11:38 AM

All replies