public static ICell GetOrCreateCol(this IRow row, int col)
{
ICell result = row.GetCell(col);
if (result == null)
{
result = row.CreateCell(col);
}
return result;
}
/// <summary>
///
/// </summary>
/// <param name="row"></param>
/// <param name="index"></param>
/// <param name="callback"></param>
/// <returns></returns>
public static ICell CreateCell(this IRow row, int index, Action<ICell> callback)
{
if (row == null)
{
throw new ArgumentNullException(nameof(row));
}
if (index < 0)
{
throw new ArgumentException("单元格索引不能小于0！", nameof(index));
}
var cell = row.CreateCell(index);
callback(cell);
return cell;
}
static ICell GetOrCreateCell(this IRow sheetRow, int colIndex)
{
ICell cell = sheetRow.GetCell(colIndex);
if (cell == null)
cell = sheetRow.CreateCell(colIndex);
return cell;
}
/// <summary>
/// Creates a cell and sets its formula.
/// </summary>
/// <param name="row">The row.</param>
/// <param name="column">The column.</param>
/// <param name="formula">The formula to set.</param>
/// <returns>The newly created cell.</returns>
public static ICell SetFormula(this IRow row, int column, string formula)
{
var cell = row.CreateCell(column);
cell.SetCellFormula(formula);
return cell;
}
/// <summary>
/// Creates a cell and sets it to a string value.
/// </summary>
/// <param name="row">The row.</param>
/// <param name="column">The column.</param>
/// <param name="value">The value to set.</param>
/// <returns>The newly created cell.</returns>
public static ICell SetCell(this IRow row, int column, string value)
{
var cell = row.CreateCell(column);
cell.SetCellValue(value);
return cell;
}
public static HSSFCell CreateCell(this HSSFRow row, string ColumnAlphaBet)
{
return row.CreateCell(Col(ColumnAlphaBet));
}
public static ICell CreateCell(this IRow row, int colId, ICellStyle cellStyle)
{
ICell cell = row.CreateCell(colId);
cell.CellStyle = cellStyle;
return cell;
}
