public void TestNotCreateEmptyCells()
{
IWorkbook wb = new HSSFWorkbook();
Npoi.Core.SS.UserModel.ISheet sheet = new SheetBuilder(wb, testData).Build();
Assert.AreEqual(sheet.PhysicalNumberOfRows, 3);
Npoi.Core.SS.UserModel.IRow firstRow = sheet.GetRow(0);
Npoi.Core.SS.UserModel.ICell firstCell = firstRow.GetCell(0);
Assert.AreEqual(firstCell.CellType, CellType.Numeric);
Assert.AreEqual(1.0, firstCell.NumericCellValue, 0.00001);
Npoi.Core.SS.UserModel.IRow secondRow = sheet.GetRow(1);
Assert.IsNotNull(secondRow.GetCell(0));
Assert.IsNull(secondRow.GetCell(2));
Npoi.Core.SS.UserModel.IRow thirdRow = sheet.GetRow(2);
Assert.AreEqual(CellType.String, thirdRow.GetCell(0).CellType);
string cellValue = thirdRow.GetCell(0).StringCellValue;
Assert.AreEqual(testData[2][0].ToString(), cellValue);
Assert.AreEqual(CellType.Formula, thirdRow.GetCell(2).CellType);
Assert.AreEqual("A1+B2", thirdRow.GetCell(2).CellFormula);
}
public override bool Equals(object obj)
{
Npoi.Core.SS.UserModel.ICell cellb = ((HSSFEvaluationCell)obj)._cell;
return(_cell.RowIndex == cellb.RowIndex &&
_cell.ColumnIndex == cellb.ColumnIndex &&
_cell.CellFormula == cellb.CellFormula &&
_cell.Sheet == cellb.Sheet);
}
public void TestEmptyCells()
{
Npoi.Core.SS.UserModel.IWorkbook wb = new HSSFWorkbook();
Npoi.Core.SS.UserModel.ISheet sheet = new SheetBuilder(wb, testData).SetCreateEmptyCells(true).Build();
Npoi.Core.SS.UserModel.ICell emptyCell = sheet.GetRow(1).GetCell(1);
Assert.IsNotNull(emptyCell);
Assert.AreEqual(CellType.Blank, emptyCell.CellType);
}
public HSSFEvaluationCell(Npoi.Core.SS.UserModel.ICell cell)
{
_cell = cell;
_evalSheet = new HSSFEvaluationSheet((HSSFSheet)cell.Sheet);
}
public HSSFEvaluationCell(Npoi.Core.SS.UserModel.ICell cell, IEvaluationSheet evalSheet)
{
_cell = cell;
_evalSheet = evalSheet;
}
