Change Handlers Using Views
You can set an updatable view as a change handler for any object or for the view itself.
In this case, SaveToDB products will save changes to the target view immediately after cell changes.
Here is a sample configuration in the xls.handlers table:
Target views must have primary key or identity columns, which 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.