SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / getDeletedRows Method
In This Topic
    getDeletedRows Method
    In This Topic
    Gets the deleted row collection.
    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


    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


    Worksheet type