public static Cell CreateNumberCell(int columnIndex, int rowIndex, int cellValue)
{
var cell = new Cell
{
DataType = CellValues.Number,
CellReference = SpreadsheetExtensions.GetColumnName(columnIndex) + rowIndex
};
var value = new CellValue {
Text = cellValue.ToString()
};
cell.AppendChild(value);
return(cell);
}
public static Cell CreateTextCell(int columnIndex, int rowIndex, object cellValue)
{
var cell = new Cell
{
DataType = CellValues.InlineString,
CellReference = SpreadsheetExtensions.GetColumnName(columnIndex) + rowIndex
};
var inlineString = new InlineString();
var t = new Text {
Text = cellValue?.ToString()
};
inlineString.AppendChild(t);
cell.AppendChild(inlineString);
return(cell);
}