Skip to content
This repository has been archived by the owner on Aug 1, 2019. It is now read-only.

Latest commit

 

History

History
76 lines (45 loc) · 4.77 KB

README.md

File metadata and controls

76 lines (45 loc) · 4.77 KB
Raw

[ARCHIVED] Excel-Add-in-Bind-To-Table

Note: This repo is archived and no longer actively maintained. Security vulnerabilities may exist in the project, or its dependencies. If you plan to reuse or run any code from this repo, be sure to perform appropriate security checks on the code or dependencies first. Do not use this project as the starting point of a production Office Add-in. Always start your production code by using the Office/SharePoint development workload in Visual Studio, or the Yeoman generator for Office Add-ins, and follow security best practices as you develop the add-in.

Demonstrates how to use the JavaScript API for Office to bind an add-in to a named table in Microsoft Excel 2013 or Microsoft Word 2013, extract data from the table, react to events in the table, and set data back into the table.

Description

This add-in code sample binds a Stock Ticker add-in to a named table that is included in the solution project. The code that uses the Binding object of the JavaScript API for Office is included in the UpdateTable.js file of the solution. The code sample binds to a table named "Stocks" on the worksheet labeled "Sheet1."

The sample demonstrates how to establish a binding between a region in an Office file —a named table, in this case— and an add-in for Office. Once the binding has been established, the add-in adds a handler to the BindingDataChanged event of the binding. When the event handler executes, the add-in retrieves a selection of the data from the table. It then removes the event handler from the binding, updates the table, and then adds the event handler back to the binding.

For more information about the JavaScript API for Office and working with bindings, see Binding to regions in a document or spreadsheet.

Prerequisites

This sample requires the following:

  • Excel 2013
  • Visual Studio 2012 or later and Office Developer Tools for Visual Studio
  • Internet Explorer 9 or later.

Key components

The Stock Ticker sample add-in app contains the following:

  • CodeSample_BindingAppToXLTable project.
  • CodeSample_BindingAppToXLTable.xml manifest file
  • Stocks.xlsx file that contains a table named "Stocks" on a spreadsheet named "Sheet1."
  • CodeSample_BindingAppToXLTableWeb project
  • Home.html file, which contains the HTML control for the add-in's user interface.
  • Home.js file, which contains the event handler for the Office.initialize event of the add-in.
  • UpdateTable.js file, which contains the self-executing anonymous function that creates the binding, adds an event handler to the binding, and contains all of the methods for getting and setting data from the binding.

Configure the sample

To configure the Stock Ticker, set the StartAction -> Start Document property of the CodeSample_BindingAppToTable project to 'Stocks.xslx'.

Build the sample

Choose the F5 key to build and deploy the add-in.

Run and test the sample

  1. Choose the F5 key to build and deploy the add-in.
  2. Insert the add-in into the Stocks.xlsx file when you debug the sample (Insert tab, Add-ins for Office button).

Note

If you save the workbook while debugging, the add-in is persisted in the workbook. If you do so, you won't have to reinsert the add-in into the workbook during future debugging sessions.

  1. In the add-in, choose Set binding.
  2. In the table on Stocks.xlsx, make a change to one of the values in the first column in the right.

Troubleshooting

If the app fails to install, ensure that the XML in your CodeSample_BindingAppToXLTable.xml file parses correctly.

If you change the code in the StockTicker.getStockQuotes method to call an external stock quote service, be aware that cross-domain scripting restrictions still apply.

If the app generates errors whenever you try to update the table, ensure that you have entered correct values for the tableName and bindingName variables in the UpdateTable.js file.

Change log

  • First release. March 8, 2013.
  • GitHub release. August 14, 2015.

Related content

This project has adopted the Microsoft Open Source Code of Conduct. For more information, see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.