Saturday, January 18th, 2020 / by Angie
You need the following to set up the development environment:
• Down and install the Visual Studio Code.
• Install the latest version of Azure Functions Core Tools. The demo application does not have the latest features. Make sure you download and install the updated version.
• Install a C# extension. VS Code Extensions have many C# extensions. Use one that suits the Visual Studio Code.
• Down and install the latest Azure Functions extensions.
• Install .Net Core 2.2. Its latest version allows you to integrate Azure with Excel quickly.
Apart from these prerequisites, you will also require an Azure subscription. Additionally, you also need an Office 365 account. You can register in the Office 365 Developer Program. It provides a one-year free subscription.
Follow the steps below to integrate Microsoft Azure with Excel.
1. Go to the Azure portal. Find the Logic App Designer and open the logic app. Usually, it remains open. If not, you need to open it manually from the Logic App Designer.
2. Select Next Step from the trigger.
3. Remember, the Logic App Designer cannot load tables with more than 100 columns. Try to reduce the number of columns to make the design run smoothly.
4. The Logic App Designer will prompt you to sign up with your Office 365 account. Enter your credentials and hit Login. It helps create a connection between Excel Online and data accessing path.
5. Select one of the actions you want to integrate with Microsoft Azure. Continue providing necessary details to build the logic’s workflow.
For customized functions, you can open the Custom Function Project folder in Visual Studio Code. Use Ctrl + Shift + ` to run the command line. You can also use “$ npm run start” command to start Excel automatically and also sideload the custom functions.
Integrating Microsoft Azure with Excel is not challenging if you follow these steps. Most developers follow them to add customized functions.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.