GridData.Data operator

Introduced

v4.0

Description

Returns or sets the entire 2-dimensional array of cell data. The data is represented in a 2-dimensional SAFEARRAY of Variants.

The first dimension is the column and the second dimension is the row.

Provided that the GridData.RowCount and GridData.ColumnCount have been previously set, it is also possible to set the property with a 1-dimensional SAFEARRAY or with a JScript Array. In this case the array must contain Row * Column items and the data is interpreted to be ordered row by row rather than column by column.

Using this property it is possible to manipulate data from any Softimage method which returns a 2-dimensional array, for example ClusterProperty data. This is demonstrated in one of the examples.

C# Syntax

// get accessor

Object rtn = GridData.Data;

// set accessor

GridData.Data = Object;

Examples

1. VBScript Example

'Demonstrate setting data with the GridData.Data method

set oGridData = XSIFactory.CreateGridData

'Create an array with 2 columns

'and 4 rows.  

dim mydata( 1, 3 )

'Initialize the data (we leave one row empty)

mydata( 0, 0 ) = 12000

mydata( 1, 0 ) = "Col1Row0"

mydata( 0, 1 ) = "Col0Row1"

mydata( 1, 1 ) = 4.567

mydata( 0, 3 ) = "Col0Row3"

mydata( 1, 3 ) = Now 	'Store current time

'It is not necessary to set the 

'rows and columns if we provide a complete

'2D array

oGridData.Data = mydata

logmessage "Columns: " & oGridData.ColumnCount & _

	" Rows: " & oGridData.RowCount

logmessage "Data contents:"

'Print out the table of items

dim i

for i = 0 to oGridData.RowCount - 1

	logmessage oGridData.GetCell( 0, i ) & vbTab & vbTab & vbTab & _

		oGridData.GetCell( 1, i )

next 

' Output of this script is the following

' (the date on the last line will change each time it is run)

'

'INFO : "Columns: 2 Rows: 4"

'INFO : "Data contents:"

'INFO : "12000			Col1Row0"

'INFO : "Col0Row1			4.567"

'INFO : "			"

'INFO : "Col0Row3			8/27/2003 11:18:12"

2. JScript Example

//Demonstrate setting data with the GridData.Data method

var oGridData = XSIFactory.CreateGridData();

//In jscript we have no 2-D array but we

//can provide a 1-D array and tell the GridData how

//to interprete it

var myData = new Array( 8 );

//Initialize the data (we leave one row empty)

myData[ 0 ] = 12000;

myData[ 1 ] = "Col1Row0";

myData[ 2 ] = "Col0Row1";

myData[ 3 ] = 4.567;

myData[ 6 ] = "Col0Row3";

myData[ 7 ] = new Date(); 	//Store current time

oGridData.RowCount = 4 ;

oGridData.ColumnCount = 2 ;

oGridData.Data = myData ;

logmessage( "Columns: " + oGridData.ColumnCount + 

	" Rows: " + oGridData.RowCount ) ;

logmessage( "Data contents:" ) ;

//Print out the table of items

for ( var i = 0 ; i < oGridData.RowCount ; i++ )

{

	logmessage( oGridData.GetCell( 0, i ) + "\t\t\t" + 

				  oGridData.GetCell( 1, i ) ) ;

}

//Output of this script is the following

//(the date on the last line will change each time it is run)

//

//INFO : "Columns: 2 Rows: 4"

//INFO : "Data contents:"

//INFO : "12000			Col1Row0"

//INFO : "Col0Row1			4.567"

//INFO : "undefined			undefined"

//INFO : "Col0Row3			Wed Aug 27 11:25:29 EDT 2003"

See Also

GridData.SetColumnValues GridData.SetRowValues