bindColumns Method

The array of column information with data fields. If an item's type is string, the item is regarded as name.

The following settings available are:

column.name	string type	The name of the data source column.
column.displayName	string type	The text to display in the column header.
column.visible	boolean type	true if the column is visible; otherwise, false.
column.size	number type	The width of the column.
column.formatter	string type	The formatter for the column.
column.resizable	boolean type	true if the column can be resized; otherwise, false.
column.value	function type	Gets or sets the value to or from the data source for the specified item.
column.cellType	GC.Spread.Sheets.BaseCellType type	The cell type to display the column cells.

Binds the columns using the specified data fields.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.bindColumns(columns);

function bindColumns( 
   columns : Array
) : any;

Parameters

columns

The array of column information with data fields. If an item's type is string, the item is regarded as name.

The following settings available are:

column.name	string type	The name of the data source column.
column.displayName	string type	The text to display in the column header.
column.visible	boolean type	true if the column is visible; otherwise, false.
column.size	number type	The width of the column.
column.formatter	string type	The formatter for the column.
column.resizable	boolean type	true if the column can be resized; otherwise, false.
column.value	function type	Gets or sets the value to or from the data source for the specified item.
column.cellType	GC.Spread.Sheets.BaseCellType type	The cell type to display the column cells.

Example

This example binds columns.

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" },
            ];
var colInfos = [
                { name: "name", displayName: "Name", size: 70 },
                { name: "age", displayName: "Age", size: 40, resizable: false },
                { name: "birthday", displayName: "Birthday", formatter: "d/M/yy", size: 120 },
                { name: "position", displayName: "Position", size: 50, visible: false }
            ];
activeSheet.autoGenerateColumns = true;
activeSheet.setDataSource(datasource);
activeSheet.bindColumns(colInfos);

Reference

Worksheet type
Binding to Data