Excel.BindingType enum
注解
示例
// 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();
});
字段
range = "Range" | |
table = "Table" | |
text = "Text" |
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈