TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

onWorksheetChange

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