Class ExcelTable
An Excel Table
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Experior.Core.Data.OfficeOpenXml.Table
Assembly: Experior.Core.dll
Syntax
public class ExcelTable : XmlHelperProperties
Address
The address of the table
Declaration
public ExcelAddressBase Address { get; }Property Value
| Type | Description |
|---|---|
| ExcelAddressBase |
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 |
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 cusom, 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 |