'moving VB.Net DLL for Excel to a cloud service on Azure

I've got a DLL written in VB.NET that provides Excel plugin capabilities. I'd like to move it into a cloud service. As far as I can tell, there's no way to use that DLL in the web-based version of Excel, so...

Is there a way to host the DLL online and just send/receive data to the DLL pretending to be Excel?



Solution 1:[1]

  • Create VB.Net Class Library, build and run the app
  • Create web Application (your required framework)
  • Add the Existing VB.Net Class Library to the newly created Web App or add the class library dll (all the required dll's ) to the new web app.
  • All the dlls will be available in the bin folder
  • When you deploy your web App to Azure by default all the folder/ dll's will be deployed to Azure

Is there a way to host the DLL online and just send/receive data to the DLL pretending to be Excel?

  • Or else you can directly upload the required dll files to KUDU Console

UPLOADING DLLS TO REFERENCE THEM FROM AZURE WEB APP

  • Open App Services in your Azure => Click your Web App => Click “Advanced tools (Kudu)” – will open in a new tab:

  • Then “Tools” –> “ZIP Push Deploy”;

  • Then click the folder with your Web App name and go to the “bin” folder;

  • Drag&drop the dll’s you want to make reference to in your Azure Web App:
    Adding DLLs file to Azure Function

  • Now you can reference your dll's from your Azure Web App

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 HarshithaVeeramalla-MT