private static SheetData GenerateSheetdataForDetails(TestModelList data)
{
SheetData sheetData1 = new SheetData();
sheetData1.Append(CreateHeaderRowForExcel());
foreach (TestModel testmodel in data.testData)
{
Row partsRows = GenerateRowForChildPartDetail(testmodel);
sheetData1.Append(partsRows);
}
return(sheetData1);
}
public static void CreatePartsForExcel(SpreadsheetDocument document, TestModelList data)
{
SheetData sheetData = GenerateSheetdataForDetails(data);
WorkbookPart wrkBookP1 = document.AddWorkbookPart();
GenerateWorkbookPartContent(wrkBookP1);
WorkbookStylesPart wrkBookStylesP1 = wrkBookP1.AddNewPart <WorkbookStylesPart>("rId3");
GenerateWorkbookStylesPartContent(wrkBookStylesP1);
WorksheetPart wrkSheetP1 = wrkBookP1.AddNewPart <WorksheetPart>("rId1");
GenerateWorksheetPartContent(wrkSheetP1, sheetData);
}