public bool SetCellStyle(short sheet, int row, int column, int ixf, CellType type)
{
IExcelCell cell = this._workbook.Worksheets[sheet].GetCell(row, column, true);
if (cell != null)
{
cell.CellType = type;
cell.SetFormatId(ixf);
return(true);
}
return(false);
}
public bool SetCell(short sheet, int row, int column, object value, CellType type, int ixf, IExcelFormula cellFormula)
{
IExcelCell cell = this._workbook.Worksheets[sheet].GetCell(row, column, true);
if (cell == null)
{
return(false);
}
if (value != null)
{
cell.Value = value;
}
cell.SetFormatId(ixf);
cell.CellType = type;
if ((cellFormula != null) && ((cell.CellFormula == null) || !cell.CellFormula.IsArrayFormula))
{
cell.CellFormula = cellFormula;
}
return(true);
}