How to Insert rows in excel sheet using OpenXML

See more:

C#

.NET

C#4.0

.NET4

MVC4

How to add rows in excel sheet using OpenXML

Trying to insert rows in a table in excel sheet before the last row.
Implementing with following logic.

Could any please help me to achieve this.


------------------------
Sheet sheet = null;
SheetData sheetData;
DocumentFormat.OpenXml.UInt32Value sheetId;
WorksheetPart worksheetPart = null;



sheet = myWorkbook.WorkbookPart.Workbook.GetFirstChild<sheets>().Elements<sheet>().First(s => s.Name.Value.Equals(“ExcelSheetName”, StringComparison.OrdinalIgnoreCase));
worksheetPart = (WorksheetPart)myWorkbook.WorkbookPart.GetPartById(sheet.Id.Value);
sheetData = worksheetPart.Worksheet.GetFirstChild<sheetdata>();

//Trying following logic
int insertrow =3;
sheetId = UInt32Value.FromUInt32((uint)insertrow);
Row row = new Row() { RowIndex = sheetId };
sheetData.Append(row);
insertrow++;

Could anyone please provide some help.