bindColumn メソッド

指定したデータフィールドを使用して列を連結します。

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.bindColumn(index, column);

function bindColumn( 
   index : number,
   column : undefined
) : any;

パラメータ

index

列インデックス。

column

以下の設定が使用できます。

column.name	string型	データソース列の名前。
column.displayName	string型	列ヘッダに表示するテキスト。
column.visible	boolean型	列が表示される場合はtrue。それ以外の場合はfalse。
column.size	number型	列の幅。
column.formatter	string型	列のフォーマッター。
column.resizable	boolean型	列をサイズ変更できる場合はtrue。それ以外の場合はfalse。
column.value	function型	指定した項目の値をデータソースから取得するか、データソースに設定します。

使用例

This example binds specific columns.

Javascript

var test = [
{"Series0":2,"Series1":1},
{"Series0":4,"Series1":2},
{"Series0":3,"Series1":4}
];
sheet.setDataSource(test);
sheet.bindColumn(1,"Series0");
sheet.bindColumn(0,"Series1");

This example creates a data source and binds specific columns to it.

Javascript

var datasource = [
                   { name: "Alice", age: 27, birthday: "1985/08/31", position: "PM" },
                   { name: "Aimee", age: 28, birthday: "1984/07/31", position: "TL" },
                   { name: "Charles", age: 29, birthday: "1983/03/31", position: "QC" },
                   { name: "Fred", age: 30, birthday: "1982/02/20", position: "DL" },
                   { name: "Angelia", age: 31, birthday: "1981/05/30", position: "QC" },
                   { name: "Peter", age: 32, birthday: "1980/11/08", position: "QC" }
               ];
var nameColInfo = { name: "name", displayName: "Name", size: 70 };
var ageColInfo = { name: "age", displayName: "Age", size: 40, resizable: false };
var birthdayColInfo = { name: "birthday", displayName: "Birthday",formatter:"d/M/yy", size: 120 };
var positionColInfo = { name: "position", displayName: "Position", size: 50, visible: false };
sheet.autoGenerateColumns = true;
sheet.setDataSource(datasource);
sheet.bindColumn(0, nameColInfo);
sheet.bindColumn(1, ageColInfo);
sheet.bindColumn(2, birthdayColInfo);
sheet.bindColumn(3, positionColInfo);

This example binds specific columns.

Javascript

var test = [
{"Series0":2,"Series1":1},
{"Series0":4,"Series1":2},
{"Series0":3,"Series1":4}
];
sheet.setDataSource(test);
sheet.bindColumn(1,"Series0");
sheet.bindColumn(0,"Series1");

This example creates a data source and binds specific columns to it.

Javascript

var datasource = [
                   { name: "Alice", age: 27, birthday: "1985/08/31", position: "PM" },
                   { name: "Aimee", age: 28, birthday: "1984/07/31", position: "TL" },
                   { name: "Charles", age: 29, birthday: "1983/03/31", position: "QC" },
                   { name: "Fred", age: 30, birthday: "1982/02/20", position: "DL" },
                   { name: "Angelia", age: 31, birthday: "1981/05/30", position: "QC" },
                   { name: "Peter", age: 32, birthday: "1980/11/08", position: "QC" }
               ];
var nameColInfo = { name: "name", displayName: "Name", size: 70 };
var ageColInfo = { name: "age", displayName: "Age", size: 40, resizable: false };
var birthdayColInfo = { name: "birthday", displayName: "Birthday",formatter:"d/M/yy", size: 120 };
var positionColInfo = { name: "position", displayName: "Position", size: 50, visible: false };
sheet.autoGenerateColumns = true;
sheet.setDataSource(datasource);
sheet.bindColumn(0, nameColInfo);
sheet.bindColumn(1, ageColInfo);
sheet.bindColumn(2, birthdayColInfo);
sheet.bindColumn(3, positionColInfo);

参照

Worksheet タイプ
 データの連結
 データの連結