D

Data (GridData) *

Introduced

4.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

Autodesk Softimage v7.5