Class ExcelTable
An Excel Table
Implements
Inherited Members
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 |