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); }