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