Office.select method (apps for Office)
Published: February 26, 2013
Creates a promise to return a binding based on the selector string passed in.
Office.select(str, onError);
When the function you passed to the onError parameter executes, it receives an AsyncResult object that you can access from the callback function's only parameter. If the operation failed, use the AsyncResult.error property to access an Error object that provides information about the error.
The Office.select method provides access to a Binding object promise that attempts to return the specified binding when any of its asynchronous methods are invoked.
Supported formats: "bindings#bindingId", which returns a Binding object for the binding with the id of bindingId. For more information, see http://msdn.microsoft.com/en-us/library/office/apps/jj220067#AsyncProgramming_PromisesPattern and Binding to regions in a document or spreadsheet.
Note
|
|---|
|
If the select method promise successfully returns a Binding object, that object exposes only the following four methods of the Binding object: getDataAsync, setDataAsync, addHandlerAsync, and removeHandlerAsync. If the promise cannot return a Binding object, the onError callback can be used to access an asyncResult.error object to get more information. If you need to call a member of the Binding object other than the four methods exposed by the Binding object promise returned by the select method, instead use the getByIdAsync method by using the Document.bindings property and Bindings.getByIdAsync method to retrieve the Binding object. |
The following code example uses the select method to retrieve a binding with the id "cities" from the Bindings collection, and then calls the addHandlerAsync method to add an event handler for the dataChanged event of the binding.
function addBindingDataChangedEventHandler() { Office.select("bindings#cities", function onError(){}).addHandlerAsync(Office.EventType.BindingDataChanged, function (eventArgs) { doSomethingWithBinding(eventArgs.binding); }); }
|
Supported clients |
Excel 2013, Excel Web App, Word 2013 |
|
Library |
Office.js |
|
Namespace |
Office |
Note