page_type: sample products:

• office-excel
• office-365 languages:
• javascript extensions: contentType: samples technologies:
  • Add-ins platforms:
  • CSS createdDate: 3/25/2016 12:36:29 PM

Excel-Add-in-JS-WoodGrove-Expense-Trends

The WoodGrove Bank Expense Trends add-in demonstrates how you can use the new JavaScript API for Microsoft Excel 2016 to create a compelling Excel add-in. With Expense Trends, you can import expense transactions into the workbook, create dashboard and trackers, view and analyze trends, and track special transactions such as charitable donations and follow up items. The sample provides two experiences: one with task pane and another with add-in commands. The following figures show the main screens of this add-in.

Table of Contents

• Prerequisites
• Run the project
• Additional resources

Prerequisites

You'll need the following:

• Visual Studio 2015
• Office Developer Tools for Visual Studio
• Excel 2016, version 6769.2011 or later

Run the project

1. Copy the project to a local folder. Ensure that the file path is not too long, otherwise you might run into an error in Visual Studio when it tries to install the NuGet packages necessary for the project.
2. Then open the WoodGrove Expense Trends.sln in Visual Studio.
3. Press F5 to build and deploy the sample add-in. Excel launches and depending on the version of Excel 2016 you've, the add-in loads a custom tab called WoodGrove in the ribbon, or opens in a task pane to the right of the worksheet, as shown in the following figures.

Additional resources

• Office Dev Center

Copyright

Copyright (c) 2016 Microsoft. All rights reserved.

This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.