Interface IXLCells

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLCells : IEnumerable<IXLCell>, IEnumerable

Inherited Members

IEnumerable<IXLCell>.GetEnumerator()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

FormulaA1

Sets the cells' formula with A1 references.

string FormulaA1 { set; }

Property Value

string

The formula with A1 references.

FormulaR1C1

Sets the cells' formula with R1C1 references.

string FormulaR1C1 { set; }

Property Value

string

The formula with R1C1 references.

Style

IXLStyle Style { get; set; }

Property Value

IXLStyle

Value

Sets the cells' value.

Setter will clear a formula, if the cell contains a formula. If the value is a text that starts with a single quote, setter will prefix the value with a single quote through IncludeQuotePrefix in Excel too and the value of cell is set to to non-quoted text.

XLCellValue Value { set; }

Property Value

XLCellValue

Methods

Clear(XLClearOptions)

Clears the contents of these cells.

IXLCells Clear(XLClearOptions clearOptions = XLClearOptions.All)

Parameters

clearOptions XLClearOptions

Specify what you want to clear.

Returns

IXLCells

DeleteComments()

Delete the comments of these cells.

void DeleteComments()

DeleteSparklines()

Delete the sparklines of these cells.

void DeleteSparklines()

Select()

void Select()