There are several events showing that something has changed. You have to use them in order to know what has changed in the Workbook. This way you will save only the specific changes in the database.
Changing the worksheets collection:
Some cell property is changed:
Cell range is inserted or removed:
Cells are merged or unmerged:
If you want to save the entire document in the database you could use WorkbookContentChanged evet. This event is raised when something in the Workbook is changed. If multiple things are changed at once only one event will be triggered:
If you are using WorkbookContentChanged event there is no information telling you what is changed that is why you have to iterate all worksheets and all used cells in each worksheet and save it in the database. In this help article
, you can read more about how to get the used range for the entire worksheet or some of its properties.
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer
and share your thoughts.