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);
}
private 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);
}
}
static void Main(string[] args)
{
TestModelList tmList = new TestModelList();
tmList.testData = new List <TestModel>();
TestModel tm = new TestModel();
tm.TestId = 1;
tm.TestName = "Test1";
tm.TestDesc = "Tested 1 time";
tm.TestDate = DateTime.Now.Date;
tmList.testData.Add(tm);
TestModel tm1 = new TestModel();
tm1.TestId = 2;
tm1.TestName = "Test2";
tm1.TestDesc = "Tested 2 times";
tm1.TestDate = DateTime.Now.AddDays(-1);
tmList.testData.Add(tm1);
TestModel tm2 = new TestModel();
tm2.TestId = 3;
tm2.TestName = "Test3";
tm2.TestDesc = "Tested 3 times";
tm2.TestDate = DateTime.Now.AddDays(-2);
tmList.testData.Add(tm2);
TestModel tm3 = new TestModel();
tm3.TestId = 4;
tm3.TestName = "Test4";
tm3.TestDesc = "Tested 4 times";
tm3.TestDate = DateTime.Now.AddDays(-3);
tmList.testData.Add(tm);
CreateExcelFile(tmList, "c:\\00Mina");
}
static void Main(string[] args)
{
TestModelList tmList = new TestModelList();
tmList.testData = new List <TestModel>();
TestModel tm = new TestModel();
tm.TestId = 1;
tm.TestName = "Test1";
tm.TestDesc = "Tested 1 time";
tm.TestDate = DateTime.Now.Date;
tmList.testData.Add(tm);
TestModel tm1 = new TestModel();
tm1.TestId = 2;
tm1.TestName = "Test2";
tm1.TestDesc = "Tested 2 times";
tm1.TestDate = DateTime.Now.AddDays(-1);
tmList.testData.Add(tm1);
TestModel tm2 = new TestModel();
tm2.TestId = 3;
tm2.TestName = "Test3";
tm2.TestDesc = "Tested 3 times";
tm2.TestDate = DateTime.Now.AddDays(-2);
tmList.testData.Add(tm2);
TestModel tm3 = new TestModel();
tm3.TestId = 4;
tm3.TestName = "Test4";
tm3.TestDesc = "Tested 4 times";
tm3.TestDate = DateTime.Now.AddDays(-3);
tmList.testData.Add(tm);
ClsUtilitiesExcel.CreateExcelFile(tmList, "C:\\Users\\Rathore\\Documents");
}