-
Notifications
You must be signed in to change notification settings - Fork 62
/
excel.bindingtype.yml
52 lines (43 loc) · 1.66 KB
/
excel.bindingtype.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
### YamlMime:TSEnum
name: Excel.BindingType
uid: 'excel!Excel.BindingType:enum'
package: excel!
fullName: Excel.BindingType
summary: ''
remarks: >-
\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
#### Examples
```TypeScript
// Link to full sample:
https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/30-events/events-disable-events.yaml
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getItem("Sample");
const sumRange = sheet.getRange("B20:P20");
sumRange.load("columnCount");
await context.sync();
// add an event handler to each cell in the sum range
for (let i = 0; i < sumRange.columnCount; i++) {
let sumBinding = context.workbook.bindings.add(sumRange.getCell(0,i), Excel.BindingType.range, "SumBinding" + i);
sumBinding.onDataChanged.add(onSumChanged);
}
await context.sync();
});
```
isPreview: false
isDeprecated: false
fields:
- name: range
uid: 'excel!Excel.BindingType.range:member'
package: excel!
summary: '* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
value: '"Range"'
- name: table
uid: 'excel!Excel.BindingType.table:member'
package: excel!
summary: '* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
value: '"Table"'
- name: text
uid: 'excel!Excel.BindingType.text:member'
package: excel!
summary: '* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
value: '"Text"'