public void WorksheetInsertTest()
{
MemoryStream stream = SpreadsheetReader.Create();
SpreadsheetDocument doc = SpreadsheetDocument.Open(stream, true);
WorksheetPart worksheetPart = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
WorksheetWriter writer = new WorksheetWriter(doc, worksheetPart);
writer.PasteNumber("D3", "2");
writer.PasteNumber("D4", "3");
writer.PasteNumber("D5", "4");
//Add total without a calc chain
writer.FindCell("D6").CellFormula = new CellFormula("SUM(D3:D5)");
//Insert a row
writer.InsertRow(6);
writer.PasteText("H6", "New content test");
//Save to the memory stream, and then to a file
SpreadsheetWriter.Save(doc);
SpreadsheetWriter.StreamToFile(string.Format("{0}\\insertrow.xlsx", GetOutputFolder()), stream);
}
