Skip to content

Instantly share code, notes, and snippets.

@nedgrady
Created August 6, 2022 17:06
Show Gist options
  • Save nedgrady/58cda178811a9dd6f2fa35473e6b5a34 to your computer and use it in GitHub Desktop.
Save nedgrady/58cda178811a9dd6f2fa35473e6b5a34 to your computer and use it in GitHub Desktop.
[Test]
public void ExcelExportCapturesTransactionTimestamp()
{
var transaction = new Transaction
{
Timestamp = DateTime.UtcNow
};
var transcationExportBuilderUnderTest = new TransactionExportBuilder();
transcationExportBuilderUnderTest.AddTransaction(transaction);
var excelExport = transcationExportBuilderUnderTest.BuildExcelFile();
var actualTimestamp =
(DateTime)excelExport
.GetWorkbook("Export")
.GetColumn("Timestamp")
.GetDataInCellAtRow(1);
Assert.AreEqual(transaction.Timestamp.Date, actualTimestamp.Date);
Assert.AreEqual(transaction.Timestamp.Hour, actualTimestamp.Hour);
Assert.AreEqual(transaction.Timestamp.Minute, actualTimestamp.Minute);
Assert.AreEqual(transaction.Timestamp.Second, actualTimestamp.Second);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment