public ColumnValue(int col, object value, ColumnValueKind valueKind)
{
When = When.Normal;
Col = col;
Value = value?.ToString();
ValueKind = valueKind;
ValueType = value?.GetType();
}
/// <summary>
/// Initializes a new instance of the <see cref="ColumnValue"/> struct.
/// </summary>
/// <param name="col">The col.</param>
/// <param name="value">The value.</param>
/// <param name="valueKind">Kind of the value.</param>
public ColumnValue(int col, object value, ColumnValueKind valueKind)
{
When = When.Normal;
Col = col;
ValueKind = valueKind;
ValueType = value?.GetType();
Value = value?.SerializeValue(ValueType);
}
public static object GetColumnValue(this IExcelContext ctx, int col, ColumnValueKind valueKind)
{
var column = ((ExcelContext)ctx).WS.Column(col);
switch (valueKind)
{
case ColumnValueKind.BestFit: return(column.BestFit);
case ColumnValueKind.Merged: return(column.Merged);
case ColumnValueKind.Width: return(column.Width);
default: throw new ArgumentOutOfRangeException(nameof(valueKind));
}
}
public static object GetColumnValue(this IExcelContext ctx, string col, ColumnValueKind valueKind) => GetColumnValue(ctx, ExcelService.ColToInt(col), valueKind);
public static void ColumnValue(this IExcelContext ctx, int col, object value, ColumnValueKind valueKind)
{
var column = ((ExcelContext)ctx).WS.Column(col);
switch (valueKind)
{
case ColumnValueKind.AutoFit: column.AutoFit(); break;
case ColumnValueKind.BestFit: column.BestFit = value.CastValue <bool>(); break;
case ColumnValueKind.Merged: column.Merged = value.CastValue <bool>(); break;
case ColumnValueKind.Width: column.Width = value.CastValue <double>(); break;
case ColumnValueKind.TrueWidth: column.SetTrueColumnWidth(value.CastValue <double>()); break;
default: throw new ArgumentOutOfRangeException(nameof(valueKind));
}
}
public static void ColumnValue(this IExcelContext ctx, string col, object value, ColumnValueKind valueKind) => ColumnValue(ctx, ExcelService.ColToInt(col), value, valueKind);
public ColumnValue(string col, object value, ColumnValueKind valueKind) : this(ExcelService.ColToInt(col), value, valueKind)
{
}
