title: Update modified rows in Excel to SQL Server table
body: <p>I have a MS Excel vsto application where I receive data from a SQL Server table. The user can modify the data in the sheet and with an Change event </p>
  
  <pre><code>worksheet.Change += new XlsInterop.Excel.DocEvents_ChangeEventHandler(ColRangeSelChange);
  </code></pre>
  
  <p>the changed cell is directly updated in the SQL Server table.</p>
  
  <p>Now, the user first wants to review his changes before it is all saved to the database. So I want to add a 'Save' button and when the user hits the button, all changed cells / rows are updated in the database. Because the Excel sheet contains about 15000 records, I only want to update the changed rows.</p>