Change Handlers Using Tables

You can set the table as a change handler for any object or for the table itself.

In this case, SaveToDB products will save changes to the target table immediately after cell changes.

Here is a sample configuration in the xls.handlers table:

Target tables must have primary key or identity columns, and the columns must exist in the selected data.

Such handlers update only existing rows.

To mark changed rows as saved, use the _Commit word in the TARGET_WORKSHEET column.

To save new or deleted rows, users must click the Save button.