Class Table

Represents the table class used by the spreadsheet model.

Inheritance

object

TableBase

Table

Inherited Members

TableBase.inSetup

TableBase.OnRangeSet()

TableBase.Range

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.Tables

Assembly: DRIT.Spreadsheet.dll

Syntax

public class Table : TableBase

Properties

AllowsDelete

Exposes the allows delete associated with Table.

Declaration

public bool AllowsDelete { get; set; }

Property Value

Type	Description
bool

AllowsInsert

Exposes the allows insert associated with Table.

Declaration

public bool AllowsInsert { get; set; }

Property Value

Type	Description
bool

AllowsUpdate

Exposes the allows update associated with Table.

Declaration

public bool AllowsUpdate { get; set; }

Property Value

Type	Description
bool

AutoFilter

Exposes the auto filter associated with Table.

Declaration

public AutoFilter AutoFilter { get; }

Property Value

Type	Description
AutoFilter

BuiltInStyle

Specifies the built-in table style applied to this table.

Declaration

public TableStyleType? BuiltInStyle { get; set; }

Property Value

Type	Description
TableStyleType?

Remarks

Excel UI: "Table Design > Table Styles" gallery.

Setting this property to a value other than None records the built-in style name so it is written to the OOXML tableStyleInfo element on save. Set to None to remove the built-in style.

ColumnStripesVisible

Exposes the column stripes visible associated with Table.

Declaration

public bool ColumnStripesVisible { get; set; }

Property Value

Type	Description
bool

Columns

Exposes the columns associated with Table.

Declaration

public TableColumnCollection Columns { get; }

Property Value

Type	Description
TableColumnCollection

Comment

Exposes the comment associated with Table.

Declaration

public string Comment { get; set; }

Property Value

Type	Description
string

Connection

Exposes the connection associated with Table.

Declaration

public DataConnection Connection { get; set; }

Property Value

Type	Description
DataConnection

DataCellStyle

Exposes the data cell style associated with Table.

Declaration

public string DataCellStyle { get; set; }

Property Value

Type	Description
string

DataSourceType

Gets the type of data source for this table (Worksheet, Xml, or QueryTable).

Declaration

public TableType DataSourceType { get; }

Property Value

Type	Description
TableType

DisplayName

Exposes the display name associated with Table.

Declaration

public string DisplayName { get; set; }

Property Value

Type	Description
string

FirstColumnVisible

Exposes the first column visible associated with Table.

Declaration

public bool FirstColumnVisible { get; set; }

Property Value

Type	Description
bool

HasHeaders

Indicates whether the s headers condition is true for Table.

Declaration

public bool HasHeaders { get; set; }

Property Value

Type	Description
bool

HeaderRowCellStyle

Exposes the header row cell style associated with Table.

Declaration

public string HeaderRowCellStyle { get; set; }

Property Value

Type	Description
string

Id

Exposes the id associated with Table.

Declaration

public int Id { get; set; }

Property Value

Type	Description
int

InsertRow

Adds the supplied ert row to Table.

Declaration

public bool InsertRow { get; set; }

Property Value

Type	Description
bool

IsLocal

Indicates whether the local condition is true for Table.

Declaration

public bool IsLocal { get; set; }

Property Value

Type	Description
bool

IsPublic

Indicates whether the public condition is true for Table.

Declaration

public bool IsPublic { get; set; }

Property Value

Type	Description
bool

IsReadOnly

Indicates whether the read only condition is true for Table.

Declaration

public bool IsReadOnly { get; set; }

Property Value

Type	Description
bool

LastColumnVisible

Exposes the last column visible associated with Table.

Declaration

public bool LastColumnVisible { get; set; }

Property Value

Type	Description
bool

Name

Exposes the name associated with Table.

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

QueryTable

Exposes the query table associated with Table.

Declaration

public QueryTable QueryTable { get; set; }

Property Value

Type	Description
QueryTable

RangeWithoutHeader

Exposes the range without header associated with Table.

Declaration

public Range RangeWithoutHeader { get; }

Property Value

Type	Description
Range	The range without header returned by the operation.

RowStripesVisible

Exposes the row stripes visible associated with Table.

Declaration

public bool RowStripesVisible { get; set; }

Property Value

Type	Description
bool

SortState

Exposes the sort state associated with Table.

Declaration

public SortState SortState { get; set; }

Property Value

Type	Description
SortState

Style

Exposes the style associated with Table.

Declaration

public TableStyle Style { get; set; }

Property Value

Type	Description
TableStyle	The style returned by the operation.

TotalsRowCellStyle

Converts the supplied data for use with Table.

Declaration

public string TotalsRowCellStyle { get; set; }

Property Value

Type	Description
string

TotalsRowVisible

Converts the supplied data for use with Table.

Declaration

public bool TotalsRowVisible { get; set; }

Property Value

Type	Description
bool

Methods

AddFilterForColumn(string)

Adds the supplied filter for column to Table.

Declaration

public void AddFilterForColumn(string columnName)

Parameters

Type	Name	Description
string	columnName	The column name used by the operation.

AddFilterForColumn(string, Filter)

Adds the supplied filter for column to Table.

Declaration

public void AddFilterForColumn(string columnName, Filter filter)

Parameters

Type	Name	Description
string	columnName	The column name used by the operation.
Filter	filter	The filter used by the operation.

ConvertToRange()

Converts the table to a regular range, removing the table structure. The cells remain in place but are no longer part of a table.

Declaration

public void ConvertToRange()

Filter()

Exposes the filter associated with Table.

Declaration

public void Filter()

HookRowColumns()

Exposes the hook row columns associated with Table.

Declaration

protected override void HookRowColumns()

Overrides

TableBase.HookRowColumns()

UnhookRowColumns()

Exposes the unhook row columns associated with Table.

Declaration

protected override void UnhookRowColumns()

Overrides

TableBase.UnhookRowColumns()