v4.0
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.
'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" |
//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" |