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

    Return Value

    Deleted row.

    The following values can be obtained.

    row.row number Specifies the index of the deleted row
    row.originalItem object Specifies the data item of the deleted row

     

    Example
    This example gets the deleted rows.
    activeSheet.setValue(0, 0, "The 1st row", GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.setValue(1, 0, "The 2st row", GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.setValue(2, 0, "The 3st row", GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.deleteRows(1, 1);
    
    $("#button1").click(function () {
    
     var deleteRows = activeSheet.getDeletedRows();
                var len = deleteRows.length;
                for (i = 0 ; i < len; i++) {
                    var d = deleteRows[i];
                 alert("rowIndex:" + d.row);       
    }        
       });
    
    //Add a button control to the page
    <input type="button" id="button1" value="button1"/>
    See Also

    Reference

    Worksheet type