public void Generate_NullWorksheet_ThrowsException()
{
#region Arrange
var softwareSummary = new SoftwareSummary();
#endregion
#region Act
_worksheetExporter.Generate(null, softwareSummary);
#endregion
#region Assert
#endregion
}
public void Generate_UpdatesProjectFieldsCorrectly()
{
#region Arrange
_workbook = new Workbook("Software.xlsx");
var worksheet = _workbook.Worksheets["Software"];
var softwareSummary = new SoftwareSummary
{
DesignTitle = "My Title",
LastUpdated = DateTime.Now.AddDays(-3),
Company = "Fujitsu - BAS",
Department = "MAF Team",
RangeSet = "My Range Value"
};
#endregion
#region Act
_worksheetExporter.Generate(worksheet, softwareSummary);
#endregion
#region Assert
var titleValue = worksheet.Cells["C3"].Value;
var lastUpdatedValue = worksheet.Cells["C5"].DateTimeValue;
Assert.AreEqual(softwareSummary.DesignTitle, titleValue);
Assert.AreEqual(softwareSummary.LastUpdated.ToString(CultureInfo.InvariantCulture), lastUpdatedValue.ToString(CultureInfo.InvariantCulture));
Assert.AreEqual(softwareSummary.Company, _workbook.Worksheets.BuiltInDocumentProperties["Company"].Value);
Assert.AreEqual(softwareSummary.Department, _workbook.Worksheets.CustomDocumentProperties["Department"].Value);
Assert.AreEqual(softwareSummary.RangeSet, _workbook.Worksheets.GetRangeByName("RangeSet").Value);
#endregion
}
