How to Use Change Handlers with Tables in SaveToDB

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

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

Here's a sample configuration in the xls.handlers table:

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

These handlers only update existing rows.

To mark changed rows as saved, include the _Commit keyword in the TARGET_WORKSHEET column.

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