protected void SetCell(uint row, uint column, object value)
{
var cell = _worksheet.GetCell(row, column);
if (cell.Value == null || cell.Value.Equals(value) == false)
{
if (!cell.IsFormula)
{
_worksheet.SetCell(row, column, value);
}
else
{
AddSkippedCellWarning(row, column, value);
_worksheet.SetCell(row, column + 1, value);
}
}
}
bool IsTestSheet(ITabularPage excelSheet) => excelSheet.GetCell(1, 1).Value != null && (excelSheet.GetCell(1, 1).Value.ToString() == "Specification");
protected string Cell(uint row, uint column)
{
var value = _worksheet.GetCell(row, column).Value;
return((value == null) ? "" : value.ToString());
}
void AddSkippedCellWarning(uint row, uint column, object value)
{
AddWarning($"{worksheet.GetCell(1, 3).Value} Skipped updating Cell R{row}C{column} to '{value}' as it has a formula in it. Please fix this value by hand, or remove the formula and re run the test.\r\n");
}
private static bool IsTestSheet(ITabularPage excelSheet)
{
return(excelSheet.GetCell(1, 1).Value != null ? (excelSheet.GetCell(1, 1).Value.ToString() == "Specification") : false);
}
