onWorksheetChange
The callback function which is called when the specified range of the current sheet changes.
Please note that the event is not called for the undo/redo operations.
Parameters:
Name |
Type |
Description |
range |
ApiRange
|
The modified range represented as the ApiRange object. |
Example
Copy code
builder.CreateFile("xlsx");
Api.attachEvent("onWorksheetChange", function(oRange){
console.log("onWorksheetChange");
console.log(oRange.GetAddress());
});
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1");
oRange.SetValue("1");
builder.SaveFile("xlsx", "onWorksheetChange.xlsx");
builder.CloseFile();
Resulting document