title: openxml - inserting a row, moving others
body: <p>I am using openxml to create an excel report. The openxml operates on a template excel file using named ranges.</p>
  
  <p>The client requires a totals row at the end of the list of rows. Sounds like a reasonable request!!</p>
  
  <p>However, the data table I'm returning from the db can contain any number of rows. Using template rows and 'InsertBeforeSelf', my totals row is getting overridden.</p>
  
  <p>My question is, using openxml, how can I insert rows into the spreadsheet, causing the totals row to be be moved down each time a row is inserted?</p>
  
  <p>Regards ...</p>