Represents a region of cells formatted as a table.
Inheritance
object
Properties
Section titled "Properties"Comment
Section titled "Comment"Inherited from: NamedReferenceBase
Gets or sets the comment associated with the named reference or table.
public string Comment { get; set; }Inherited from: NamedReferenceBase
Gets or sets the name of the reference.
public string Name { get; set; }Scope
Section titled "Scope"Inherited from: NamedReferenceBase
Gets the scope of the named reference.
public object Scope { get; }AreaFormats
Section titled "AreaFormats"Gets the collection of formats used for each area of the .
public WorksheetTableAreaFormatsCollection<WorksheetTableArea> AreaFormats { get; }Columns
Section titled "Columns"Gets the collection of columns in the table.
public WorksheetTableColumnCollection Columns { get; }DataAreaRegion
Section titled "DataAreaRegion"Gets the which represents the region of cells in the data area of the table.
public WorksheetRegion DataAreaRegion { get; }DisplayBandedColumns
Section titled "DisplayBandedColumns"Gets or sets the value which indicates whether the alternate column format should be applied to the appropriate columns of the .
public bool DisplayBandedColumns { get; set; }DisplayBandedRows
Section titled "DisplayBandedRows"Gets or sets the value which indicates whether the alternate row format should be applied to the appropriate rows of the .
public bool DisplayBandedRows { get; set; }DisplayFirstColumnFormatting
Section titled "DisplayFirstColumnFormatting"Gets or sets the value which indicates whether the first column format should be applied to the appropriate column of the .
public bool DisplayFirstColumnFormatting { get; set; }DisplayLastColumnFormatting
Section titled "DisplayLastColumnFormatting"Gets or sets the value which indicates whether the last column format should be applied to the appropriate column of the .
public bool DisplayLastColumnFormatting { get; set; }HeaderRowRegion
Section titled "HeaderRowRegion"Gets the which represents the region of cells in the header row of the table.
public WorksheetRegion HeaderRowRegion { get; }IsFilterUIVisible
Section titled "IsFilterUIVisible"Gets or sets the value indicating whether to allow filtering and show filter buttons in the table headers.
public bool IsFilterUIVisible { get; set; }IsHeaderRowVisible
Section titled "IsHeaderRowVisible"Gets or sets the value which indicates whether the row containing column headers should be displayed.
public bool IsHeaderRowVisible { get; set; }IsTotalsRowVisible
Section titled "IsTotalsRowVisible"Gets or sets the value which indicates whether the row containing column totals should be displayed.
public bool IsTotalsRowVisible { get; set; }SortSettings
Section titled "SortSettings"Gets the settings which determine how the data within the table should be sorted.
public SortSettings<WorksheetTableColumn> SortSettings { get; }Style
Section titled "Style"Gets or sets the style to use on the .
public WorksheetTableStyle Style { get; set; }TotalsRowRegion
Section titled "TotalsRowRegion"Gets the which represents the region of cells in the totals row of the table.
public WorksheetRegion TotalsRowRegion { get; }WholeTableRegion
Section titled "WholeTableRegion"Gets the which represents the region of cells in the whole table, including the header and totals rows, if visible.
public WorksheetRegion WholeTableRegion { get; }Worksheet
Section titled "Worksheet"Gets the to which the table belongs.
public Worksheet Worksheet { get; }Methods
Section titled "Methods"ClearFilters()
Section titled "ClearFilters()"Clears all filters from the columns in the table.
public void ClearFilters()Returns any
ClearSortConditions()
Section titled "ClearSortConditions()"Clears all sort conditions from the columns in the table.
public void ClearSortConditions()Returns any
DeleteColumns(int, int)
Section titled "DeleteColumns(int, int)"Deletes one or more columns from the table
public void DeleteColumns(int tableColumnIndex, int count = 1)Parameters
- tableColumnIndex:
int - count:
int
Returns any
DeleteDataRows(int, int)
Section titled "DeleteDataRows(int, int)"Deletes one or more data rows from the table
public void DeleteDataRows(int dataRowIndex, int count = 1)Parameters
- dataRowIndex:
int - count:
int
Returns any
InsertColumns(int, int)
Section titled "InsertColumns(int, int)"Inserts one or more columns into the table
public void InsertColumns(int tableColumnIndex, int count = 1)Parameters
- tableColumnIndex:
int - count:
int
Returns any
InsertDataRows(int, int)
Section titled "InsertDataRows(int, int)"Inserts one or more data rows into the table
public void InsertDataRows(int dataRowIndex, int count = 1)Parameters
- dataRowIndex:
int - count:
int
Returns any
ReapplyFilters()
Section titled "ReapplyFilters()"Re-filters all data cells in the table based on the filters from the columns in the table.
public void ReapplyFilters()Returns any
ReapplySortConditions()
Section titled "ReapplySortConditions()"Re-sorts all data cells in the table based on the sort conditions from the columns in the table.
public void ReapplySortConditions()Returns any
Resize(WorksheetRegion)
Section titled "Resize(WorksheetRegion)"Resizes the table to a new range of data on the worksheet.
public void Resize(WorksheetRegion headerAndDataRegion)Parameters
- headerAndDataRegion:
WorksheetRegion
Returns any
Resize(string)
Section titled "Resize(string)"Resizes the table to a new range of data on the worksheet.
public void Resize(string headerAndDataRegionAddress)Parameters
- headerAndDataRegionAddress:
string
Returns any
Resize(string, CellReferenceMode)
Section titled "Resize(string, CellReferenceMode)"Resizes the table to a new range of data on the worksheet.
public void Resize(string headerAndDataRegionAddress, CellReferenceMode cellReferenceMode)Parameters
- headerAndDataRegionAddress:
string - cellReferenceMode:
CellReferenceMode
Returns any
ToString()
Section titled "ToString()"Gets the string representation of the table.
public override string ToString()