Show / Hide Table of Contents

Class Table

Inheritance
System.Object
TableBase
Table
Inherited Members
TableBase.inSetup
TableBase.Range
TableBase.OnRangeSet()
Namespace: DRIT.Spreadsheet.Tables
Assembly: DRIT.Spreadsheet.dll
Syntax
public class Table : TableBase

Properties

AllowsDelete

Declaration
public bool AllowsDelete { get; set; }
Property Value
Type Description
System.Boolean

AllowsInsert

Declaration
public bool AllowsInsert { get; set; }
Property Value
Type Description
System.Boolean

AllowsUpdate

Declaration
public bool AllowsUpdate { get; set; }
Property Value
Type Description
System.Boolean

AutoFilter

Declaration
public AutoFilter AutoFilter { get; }
Property Value
Type Description
AutoFilter

Columns

Declaration
public TableColumnCollection Columns { get; }
Property Value
Type Description
TableColumnCollection

ColumnStripesVisible

Declaration
public bool ColumnStripesVisible { get; set; }
Property Value
Type Description
System.Boolean

Comment

Declaration
public string Comment { get; set; }
Property Value
Type Description
System.String

Connection

Declaration
public DataConnection Connection { get; set; }
Property Value
Type Description
DataConnection

DataCellStyle

Declaration
public string DataCellStyle { get; set; }
Property Value
Type Description
System.String

DisplayName

Declaration
public string DisplayName { get; set; }
Property Value
Type Description
System.String

FirstColumnVisible

Declaration
public bool FirstColumnVisible { get; set; }
Property Value
Type Description
System.Boolean

HasHeaders

Declaration
public bool HasHeaders { get; set; }
Property Value
Type Description
System.Boolean

HeaderRowCellStyle

Declaration
public string HeaderRowCellStyle { get; set; }
Property Value
Type Description
System.String

Id

Declaration
public int Id { get; set; }
Property Value
Type Description
System.Int32

InsertRow

Declaration
public bool InsertRow { get; set; }
Property Value
Type Description
System.Boolean

IsLocal

Declaration
public bool IsLocal { get; set; }
Property Value
Type Description
System.Boolean

IsPublic

Declaration
public bool IsPublic { get; set; }
Property Value
Type Description
System.Boolean

IsReadOnly

Declaration
public bool IsReadOnly { get; set; }
Property Value
Type Description
System.Boolean

LastColumnVisible

Declaration
public bool LastColumnVisible { get; set; }
Property Value
Type Description
System.Boolean

Name

Declaration
public string Name { get; set; }
Property Value
Type Description
System.String

QueryTable

Declaration
public QueryTable QueryTable { get; set; }
Property Value
Type Description
QueryTable

RangeWithoutHeader

Declaration
public Range RangeWithoutHeader { get; }
Property Value
Type Description
Range

RowStripesVisible

Declaration
public bool RowStripesVisible { get; set; }
Property Value
Type Description
System.Boolean

SortState

Declaration
public SortState SortState { get; set; }
Property Value
Type Description
SortState

Style

Declaration
public TableStyle Style { get; set; }
Property Value
Type Description
TableStyle

TotalsRowCellStyle

Declaration
public string TotalsRowCellStyle { get; set; }
Property Value
Type Description
System.String

TotalsRowVisible

Declaration
public bool TotalsRowVisible { get; set; }
Property Value
Type Description
System.Boolean

Methods

AddFilterForColumn(String)

Declaration
public void AddFilterForColumn(string columnName)
Parameters
Type Name Description
System.String columnName

AddFilterForColumn(String, Filter)

Declaration
public void AddFilterForColumn(string columnName, Filter filter)
Parameters
Type Name Description
System.String columnName
Filter filter

Filter()

Declaration
public void Filter()

HookRowColumns()

Declaration
protected override void HookRowColumns()
Overrides
TableBase.HookRowColumns()

UnhookRowColumns()

Declaration
protected override void UnhookRowColumns()
Overrides
TableBase.UnhookRowColumns()
Back to top Generated by DocFX