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); } } }
protected void ClearSkippedCellWarnings() { worksheet.SetCell(1, 3, ""); }