Spread.Sheets Documentation
getDirtyRows Method
GC.Spread.Sheets Namespace > Worksheet type : getDirtyRows Method
Gets the dirty row collection.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: Array
value = instance.getDirtyRows();
function getDirtyRows() : Array;

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.
row.originalItem object type Specifies original data item of the row.
Example
This example gets the dirty rows.
var customers = [
               { ID: 0, Name: 'A', Info1: 'Info0' },
               { ID: 1, Name: 'B', Info1: 'Info1' },
               { ID: 2, Name: 'C', Info1: 'Info2' },
            ];
            activeSheet.autoGenerateColumns = true;
            activeSheet.setDataSource(customers);



$("#button1").click(function () {
var dirtyRows = activeSheet.getDirtyRows();
            var len = dirtyRows.length;
            if (len > 0) {
                for (var i = 0; i < len; i++) {
                    var dr = dirtyRows[i];
                    alert("row:" + dr.row);
}
}
   });

// Add a button to the page
<input type="button" id="button1" value="button1"/>
See Also

Reference

Worksheet type