Skip to content

Latest commit

 

History

History
50 lines (36 loc) · 3.45 KB

README.md

File metadata and controls

50 lines (36 loc) · 3.45 KB
Raw

Excel Bot

Excel Bot is a sample that demonstrates how to use the Microsoft Graph and specifically the Excel REST API to access Excel workbooks stored in OneDrive for Business through a conversational user interface. It is written in C# and it uses the Microsoft Bot Framework and the Language Understanding Intelligent Service (LUIS).

Note: The code in this sample was originally written for a user experience prototype and does not necessarily demonstrate how to create production quality code.

Prerequisites

This sample requires the following:

  • Visual Studio 2015 with Update 3
  • An Office 365 for business account. You can sign up for an Office 365 Developer subscription that includes the resources that you need to start building Office 365 apps.

Getting started

Complete the these steps to setup your development environment to build and test the Excel bot:

  • Clone this repo to a local folder
  • Clone and build the Excel REST API Explorer sample to the same folder. Excel Bot uses a library in the Excel REST API Explorer project to make the REST API calls to the Microsoft Graph.
  • Open the ExcelBot.sln solution file
  • Register the bot in the Bot Framework
  • Copy the bot MicrosoftAppId and MicrosoftAppPassword to the Web.config file
  • Register the bot to call the Microsoft Graph
    • Assign the following Delegated Permissions to the app: Sign in and read user profile (User.Read), Have full access to user files (Files.ReadWrite)
    • Add the bots host name to the list of Reply URLs using the format https://BOT HOST NAME
  • Copy the Azure Active Directory Client Id and Secret to the Web.config file
  • Create a new model in the LUIS service
  • Import the LUIS\excelbot.json file into LUIS
  • Train and publish the LUIS model
  • Copy the LUIS model id and subscription key to the Dialogs\ExcelBotDialog.cs file
  • (Optional) Enable Web Chat for the bot in the Bot Framework and copy the Web Chat embed template the chat.htm file
  • (Optional) To get the bot to send telemetry to Visual Studio Application Insights, copy the instrumentation key to the following files: ApplicationInsights.config, default.htm, loggedin.htm, chat.htm
  • Build the solution
  • Press F5 to start the bot locally
  • Test the bot locally with the Bot Framework Emulator
  • Create a web app in Azure
  • Replace the bots host name in the Web.config file
  • Publish the solution to the Azure web app
  • Test the deployed bot using the Web Chat control by browsing to the chat.htm page

Give us your feedback

Your feedback is important to us.

Check out the sample code and let us know about any questions and issues you find by submitting an issue directly in this repository. Provide repro steps, console output, and error messages in any issue you open.

Copyright

Copyright (c) 2016 Microsoft. All rights reserved.