public static AuditingQuestionnaireSetupDto GetSetup()
{
var setup = new AuditingQuestionnaireSetupDto
{
Title = "SHE Test",
Facility = "Fac 567",
Site = "North Wacker Drive, Peoria, IL, USA",
Department = "Department 1",
CustomField = "CustomField fred add",
SiteManager = "fred",
SiteManagerTitle = "manager",
AuditManager = "yan",
AuditManagerTitle = "amt",
InspectionStartDate = DateTime.Now,
InspectionEndDate = DateTime.Now.AddDays(1),
LeadInspector = "LeadInspector fred",
LeadInspectorTitle = "lit",
SiteInspector1 = "jack",
SiteInspector1Title = "wang",
// SiteInspector2 ="jia",
SiteInspector2Title = "liu",
OtherSiteInspectors = "randy",
OtherSiteInspectorsTitle = "gong",
Notes = @"To see how this works let’s do a short walkthrough of sample 6 that creates a report on a directory in the file system.
The spreadsheet is created without any template.
First sheet is a list of subdirectories and files, with an icon, name, size, and dates. The second sheet contains some statistics"
};
return(setup);
}
public static void CreateSetupSheet(ExcelPackage package, AuditingQuestionnaireSetupDto setup)
{
var worksheet = package.Workbook.Worksheets.Add("Setup");
var mergedCells = new List <ExcelRange>();
var startDate = setup.InspectionStartDate.ToShortDateString();
var endDate = setup.InspectionEndDate.ToShortDateString();
worksheet
.SetFromValue("Facility", setup.Facility).NewRow(mergedCells)
.SetFromValue("Site", setup.Site).NewRow(mergedCells)
.SetFromValue("Department", setup.Department).NewRow(mergedCells)
.SetFromValue("CustomField", setup.CustomField).NewRow(mergedCells)
.SetFromValue("Site Manager", setup.SiteManager, "Site Manager Title", setup.SiteManagerTitle)
.SetFromValue("Audit Manager", setup.AuditManager, "Audit Manager Title", setup.AuditManagerTitle)
.SetFromValue("Managers", setup.Managers, "Managers Title", setup.ManagersTitle)
.NewRow(mergedCells)
.SetTitle("Inspection", mergedCells).NewRow(mergedCells)
.SetFromValue("Start Date", startDate, "End Date", endDate).NewRow(mergedCells)
.SetFromValue("Lead Inspector", setup.LeadInspector, "Lead Inspector Title", setup.LeadInspectorTitle)
.SetFromValue("Site Inspector1", setup.SiteInspector1, "Site Inspector1 Title", setup.SiteInspector1Title)
.SetFromValue("Site Inspector2", setup.SiteInspector2, "Site Inspector2 Title", setup.SiteInspector2Title)
.SetFromValue(
"Other Site Inspectors", setup.OtherSiteInspectors,
"Other Site Inspectors Title", setup.OtherSiteInspectorsTitle)
.NewRow(mergedCells)
.SetFromValue("Notes", setup.Notes);
worksheet.Row(worksheet.Dimension.Rows).Height = 100;
worksheet.MergeCellsToMatchMaxColumn(mergedCells);
worksheet.Cells.AutoFitColumns();
worksheet.Column(2).Width = 40;
worksheet.Column(5).Width = 40;
worksheet.SetTopTitle(setup.Title + " - Audit").AddTopImages(1, 20);
}
