public void 書き込んだDoubleをNumericCellValueで取得できること () { var expected = 1.2D; var fileName = Path.GetTempFileName (); var table = new DataTable ("Sheet 1"); table.Columns.Add ("C1", typeof(double)); table.Rows.Add (expected); table.WriteXls (this._fileName); var workbook = OpenWorkbook (this._fileName); var cell = workbook.GetSheetAt (0).GetRow (0).GetCell (0); Assert.That (cell.CellType, Is.EqualTo (NPOI.SS.UserModel.CellType.NUMERIC)); Assert.That (cell.NumericCellValue, Is.EqualTo (expected)); }
public void 書き込んだDateTimeをDateCellValueで取得できること () { var today = DateTime.Today; var fileName = Path.GetTempFileName (); var table = new DataTable ("Sheet 1"); table.Columns.Add ("C1", typeof(DateTime)); table.Rows.Add (today); table.WriteXls (this._fileName); var workbook = OpenWorkbook (this._fileName); var cell = workbook.GetSheetAt (0).GetRow (0).GetCell (0); Assert.That (cell.CellType, Is.EqualTo (NPOI.SS.UserModel.CellType.NUMERIC)); Assert.That (cell.DateCellValue, Is.EqualTo (today)); }
public void 書き込んだDateTimeNowをDateCellValueで取得できること () { var now = DateTime.UtcNow; var fileName = Path.GetTempFileName (); var table = new DataTable ("Sheet 1"); table.Columns.Add ("C1", typeof(DateTime)); table.Rows.Add (now); table.WriteXls (this._fileName); var workbook = OpenWorkbook (this._fileName); var cell = workbook.GetSheetAt (0).GetRow (0).GetCell (0); Assert.That (cell.CellType, Is.EqualTo (NPOI.SS.UserModel.CellType.NUMERIC)); // EqualTo だと失敗する (内部的に double で保持しているためと考える Assert.That (cell.DateCellValue.ToString (), Is.EqualTo (now.ToString ())); }
public void 書き込んだBooleanをBooleanCellValueで取得できること () { var fileName = Path.GetTempFileName (); var table = new DataTable ("Sheet 1"); table.Columns.Add ("C1", typeof(bool)); table.Rows.Add (true); table.WriteXls (this._fileName); var workbook = OpenWorkbook (this._fileName); var cell = workbook.GetSheetAt (0).GetRow (0).GetCell (0); Assert.That (cell.CellType, Is.EqualTo (NPOI.SS.UserModel.CellType.BOOLEAN)); Assert.That (cell.BooleanCellValue, Is.True); }