OpenXML add new row to existing Excel file [closed]

Question

I've got lots of XLSX files and I need to append a new row after the last one in the file. I'm using OpenXML and so far I know how to open/create spreadsheet, but my search for adding new rows to existing files returned nothing. Any ideas ?

Answer 1

If you use OpenXML SDK 2.5 (Runtime) v4.0.30319 there is no Insert method, but one can use InsertAt instead as follows:

sheetData.InsertAt(new Row() { RowIndex = 0 }, 0);