类: CellBindingSource

Sheets.Bindings.CellBindingSource

Table of contents

构造方法

• constructor

方法

• getSource
• getValue
• setValue

构造方法

constructor

• new CellBindingSource(source)

单元格绑定源

代码示例

var person = {name: "Wang feng", age: 25, address: {postcode: "710075"}};
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(person);
activeSheet.setBindingPath(0, 0, "name");
activeSheet.setBindingPath(1, 1, "age");
activeSheet.setBindingPath(3, 3, "address.postcode");
activeSheet.setDataSource(source);

参数

方法

getSource

▸ getSource(): Object

获取包装的数据源以进行单元绑定

代码示例

//本示例获取名称
var person = { name: "Wang feng", age: 25, address: { postcode: "710075" } };
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(person);
activeSheet.setBindingPath(0, 0, "name");
activeSheet.setBindingPath(1, 1, "age");
activeSheet.setBindingPath(3, 3, "address.postcode");
activeSheet.setDataSource(source);
alert(source.getSource().name);

返回值

Object

原始数据源

getValue

▸ getValue(path): Object

通过绑定路径获取源的值

代码示例

//本示例获取值
var person = {name: "Wang feng", age: 25, address: {postcode: "710075"}};
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(person);
activeSheet.setBindingPath(0, 0, "name");
activeSheet.setBindingPath(1, 1, "age");
activeSheet.setBindingPath(3, 3, "address.postcode");
activeSheet.setDataSource(source);
alert(source.getValue("name"));

参数

返回值

Object

返回指定路径上的绑定源的值

setValue

▸ setValue(path, value): void

通过绑定路径设置源的值

代码示例

//本示例设置名称值
var person = {name: "Wang feng", age: 25, address: {postcode: "710075"}};
var source = new GC.Spread.Sheets.Bindings.CellBindingSource(person);
activeSheet.setBindingPath(0, 0, "name");
activeSheet.setBindingPath(1, 1, "age");
activeSheet.setBindingPath(3, 3, "address.postcode");
activeSheet.setDataSource(source);
source.setValue("name", "test");
activeSheet.resumePaint();
activeSheet.repaint();

参数

返回值

void