SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getInsertRows Method
In This Topic
    getInsertRows Method
    In This Topic
    Gets the inserted row collection.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.getInsertRows();
    function getInsertRows() : any;

    Return Value

    The following values can be returned:

    row.row number type Specifies row index.
    row.item object type Specifies data item of the row.
    Example
    This example gets the inserted rows.
    activeSheet.getRange(0, -1, 1, -1).backColor("Red");
    activeSheet.setValue(0, 0, "value");
    activeSheet.addRows(0, 1);
    
    $("#button1").click(function () {
    
                 var insertRows = activeSheet.getInsertRows();
                var len = insertRows.length;
                for(var i = 0; i < len; i++){
                    var r = insertRows[i];
                 alert("rowIndex:" + r.row);       
    }        
       });
    
    // Add button control to page
    <input type="button" id="button1" value="button1"/>
    See Also

    Reference

    Worksheet type