Skip to content

Latest commit

 

History

History
88 lines (68 loc) · 4.39 KB

machine-learning-excel-add-in-for-web-services.md

File metadata and controls

88 lines (68 loc) · 4.39 KB
title description services documentationcenter author manager editor tags ms.assetid ms.service ms.devlang ms.topic ms.tgt_pltfrm ms.workload ms.date ms.author
Excel add-in for Machine Learning Web services | Microsoft Docs
How to use Azure Machine Learning Web services directly in Excel without writing any code.
machine-learning
tedway
jhubbard
cgronlun
9618079d-502f-4974-a3e2-8f924042a23f
machine-learning
na
article
na
data-services
11/15/2016
tedway;garye

Excel Add-in for Azure Machine Learning Web services

Excel makes it easy to call Web services directly without the need to write any code.

Steps to Use an Existing Web service in the Workbook

  1. Open the sample Excel file, which contains the Excel add-in and data about passengers on the Titanic.

  2. Choose the Web service by clicking it - "Titanic Survivor Predictor (Excel Add-in Sample) [Score]" in this example.

    Select Web service

  3. This will take you to the Predict section. This workbook already contains sample data, but for a blank workbook you can select a cell in Excel and click Use sample data.

  4. Select the data with headers and click the input data range icon. Make sure the "My data has headers" box is checked.

  5. Under Output, enter the cell number where you want the output to be, for example "H1" here.

  6. Click Predict.

    Predict section

Steps to Add a New Web service

Deploy a Web service or use an existing Web service. For more information on deploying a Web service, see Walkthrough Step 5: Deploy the Azure Machine Learning Web service.

Get the API key for your Web service. Where you do this depends on whether you published a Classic Machine Learning Web service of a New Machine Learning Web service.

Use a Classic Web service

  1. In Machine Learning Studio, click the WEB SERVICES section in the left pane, and then select the Web service.

    Studio select a Web service

  2. Copy the API key for the Web service.

    Studio API key

  3. On the DASHBOARD tab for the Web service, click the REQUEST/RESPONSE link.

  4. Look for the Request URI section. Copy and save the URL.

Note

It is now possible to sign into the Azure Machine Learning Web Services portal to obtain the API key for a Classic Machine Learning Web service.

Use a New Web service

  1. In the Azure Machine Learning Web Services portal, click Web Services, then select your Web service.
  2. Click Consume.
  3. Look for the Basic consumption info section. Copy and save the Primary Key and the Request-Response URL.

Steps to Add a New Web service

  1. Deploy a Web service or use an existing Web service. For more information on deploying a Web service, see Walkthrough Step 5: Deploy the Azure Machine Learning Web service.

  2. Click Consume.

  3. Look for the Basic consumption info section. Copy and save the Primary Key and the Request-Response URL.

  4. In Excel, go to the Web Services section (if you are in the Predict section, click the back arrow to go to the list of Web services).

    Go to Web service selection

  5. Click Add Web Service.

  6. Paste the URL into the Excel add-in text box labeled URL.

  7. Paste the API/Primary key into the text box labeled API key.

  8. Click Add.

    URL and API key for a classic Web service.

  9. To use the Web service, follow the preceding directions, "Steps to Use an Existing Web Service."

Sharing Your Workbook

If you save your workbook, then the API/Primary key for the Web services you have added is also saved. That means you should only share the workbook with individuals you trust.

Ask any questions in the following comment section or on our forum.