Table of Contents

Interface IXLTableField

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public interface IXLTableField
Extension Methods

Properties

Column

Gets the corresponding column for this table field. Includes the header and footer cells

IXLRangeColumn Column { get; }

Property Value

IXLRangeColumn

The column.

DataCells

Gets the collection of data cells for this field Excludes the header and footer cells

IXLCells DataCells { get; }

Property Value

IXLCells

The data cells

HeaderCell

Gets the header cell for the table field.

IXLCell HeaderCell { get; }

Property Value

IXLCell

The header cell.null, if the table doesn't have set ShowHeaderRow.

Index

Gets the index of the column (0-based).

int Index { get; }

Property Value

int

The index.

Name

Gets or sets the name/header of this table field. The corresponding header cell's value will change if you set this.

string Name { get; set; }

Property Value

string

The name.

Table

Gets the underlying table for this table field.

IXLTable Table { get; }

Property Value

IXLTable

TotalsCell

Gets the footer cell for the table field.

IXLCell TotalsCell { get; }

Property Value

IXLCell

The footer cell. null, if the table doesn't have set ShowTotalsRow.

TotalsRowFormulaA1

Gets or sets the totals row formula in A1 format.

string TotalsRowFormulaA1 { get; set; }

Property Value

string

The totals row formula a1.

TotalsRowFormulaR1C1

Gets or sets the totals row formula in R1C1 format.

string TotalsRowFormulaR1C1 { get; set; }

Property Value

string

The totals row formula r1 c1.

TotalsRowFunction

Gets or sets the totals row function.

XLTotalsRowFunction TotalsRowFunction { get; set; }

Property Value

XLTotalsRowFunction

The totals row function.

TotalsRowLabel

Gets or sets the totals row label (the leftmost cell in the totals row).

string TotalsRowLabel { get; set; }

Property Value

string

The totals row label.

Methods

Delete()

Deletes this table field from the table.

void Delete()

IsConsistentDataType()

Determines whether all cells this table field have a consistent data type.

bool IsConsistentDataType()

Returns

bool

IsConsistentFormula()

Determines whether all cells this table field have a consistent formula.

bool IsConsistentFormula()

Returns

bool

IsConsistentStyle()

Determines whether all cells this table field have a consistent style.

bool IsConsistentStyle()

Returns

bool