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 partSheetData = GenerateSheetdataForDetails(data);
WorkbookPart workbookPart1 = document.AddWorkbookPart();
GenerateWorkbookPartContent(workbookPart1);
WorkbookStylesPart workbookStylesPart1 = workbookPart1.AddNewPart <WorkbookStylesPart>("rId3");
GenerateWorkbookStylesPartContent(workbookStylesPart1);
WorksheetPart worksheetPart1 = workbookPart1.AddNewPart <WorksheetPart>("rId1");
GenerateWorksheetPartContent(worksheetPart1, partSheetData);
}
public static void CreateExcelFile(TestModelList data, string OutPutFileDirectory)
{
var datetime = DateTime.Now.ToString().Replace("/", "_").Replace(":", "_");
string fileFullname = Path.Combine(OutPutFileDirectory, "Output.xlsx");
if (File.Exists(fileFullname))
{
fileFullname = Path.Combine(OutPutFileDirectory, "Output_" + datetime + ".xlsx");
}
using (SpreadsheetDocument package = SpreadsheetDocument.Create(fileFullname, SpreadsheetDocumentType.Workbook))
{
CreatePartsForExcel(package, data);
}
}