Class ExcelTable

An Excel Table

Inheritance

System.Object

XmlHelper

ExcelTable

Implements

System.Collections.Generic.IEqualityComparer<ExcelTable>

Inherited Members

XmlHelper.AddSchemaNodeOrder(String[], String[])

XmlHelper.AddSchemaNodeOrder(String[], String[], Int32[])

XmlHelper.CreatespPrNode(String, Boolean)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Table

Assembly: EPPlus.dll

Syntax

public class ExcelTable : XmlHelper, IEqualityComparer<ExcelTable>

Properties

Address

The address of the table

Declaration

public ExcelAddressBase Address { get; }

Property Value

Type	Description
ExcelAddressBase

AutoFilter

Autofilter settings for the table

Declaration

public ExcelAutoFilter AutoFilter { get; }

Property Value

Type	Description
ExcelAutoFilter

Columns

Collection of the columns in the table

Declaration

public ExcelTableColumnCollection Columns { get; }

Property Value

Type	Description
ExcelTableColumnCollection

DataCellStyleName

Named style used for the data cells

Declaration

public string DataCellStyleName { get; set; }

Property Value

Type	Description
System.String

HeaderRowCellStyle

Named style used for the header row

Declaration

public string HeaderRowCellStyle { get; set; }

Property Value

Type	Description
System.String

Name

The name of the table object in Excel

Declaration

public string Name { get; set; }

Property Value

Type	Description
System.String

Range

The table range

Declaration

public ExcelRangeBase Range { get; }

Property Value

Type	Description
ExcelRangeBase

ShowColumnStripes

Display banded columns

Declaration

public bool ShowColumnStripes { get; set; }

Property Value

Type	Description
System.Boolean

ShowFilter

If the header row has an autofilter

Declaration

public bool ShowFilter { get; set; }

Property Value

Type	Description
System.Boolean

ShowFirstColumn

Display special formatting for the first row

Declaration

public bool ShowFirstColumn { get; set; }

Property Value

Type	Description
System.Boolean

ShowHeader

If the header row is visible or not

Declaration

public bool ShowHeader { get; set; }

Property Value

Type	Description
System.Boolean

ShowLastColumn

Display special formatting for the last row

Declaration

public bool ShowLastColumn { get; set; }

Property Value

Type	Description
System.Boolean

ShowRowStripes

Display banded rows

Declaration

public bool ShowRowStripes { get; set; }

Property Value

Type	Description
System.Boolean

ShowTotal

If the total row is visible or not

Declaration

public bool ShowTotal { get; set; }

Property Value

Type	Description
System.Boolean

StyleName

The style name for custum styles

Declaration

public string StyleName { get; set; }

Property Value

Type	Description
System.String

TableStyle

The table style. If this property is custom, the style from the StyleName propery is used.

Declaration

public TableStyles TableStyle { get; set; }

Property Value

Type	Description
TableStyles

TableUri

The package internal URI to the Table Xml Document.

Declaration

public Uri TableUri { get; }

Property Value

Type	Description
System.Uri

TableXml

Provides access to the XML data representing the table in the package.

Declaration

public XmlDocument TableXml { get; set; }

Property Value

Type	Description
System.Xml.XmlDocument

TotalsRowCellStyle

Named style used for the total row

Declaration

public string TotalsRowCellStyle { get; set; }

Property Value

Type	Description
System.String

WorkSheet

The worksheet of the table

Declaration

public ExcelWorksheet WorkSheet { get; set; }

Property Value

Type	Description
ExcelWorksheet

Methods

Equals(ExcelTable, ExcelTable)

Checkes if two tables are the same

Declaration

public bool Equals(ExcelTable x, ExcelTable y)

Parameters

Type	Name	Description
ExcelTable	x	Table 1
ExcelTable	y	Table 2

Returns

Type	Description
System.Boolean

GetHashCode(ExcelTable)

Returns a hashcode generated from the TableXml

Declaration

public int GetHashCode(ExcelTable obj)

Parameters

Type	Name	Description
ExcelTable	obj	The table

Returns

Type	Description
System.Int32	The hashcode

Implements

System.Collections.Generic.IEqualityComparer<T>