GrapeCity.Documents.Excel.ITableColumn

ITableColumn Interface

Represents a column in a table.

An ITableColumn object is a member of the ITableColumns collection, which contains all columns in an ITable.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ITableColumn

Public Interface ITableColumn

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ITableColumn tableColumn = table.Columns[0];
string name = tableColumn.Name;

Properties

Name	Description
DataBodyRange	Gets the IRange that represents the data body cells of this table column. The returned range includes only the data rows in the column and excludes the header cell and totals cell.
DataField	Gets or sets the data field name of the current table column. This property gets or sets the field name associated with the current table column.
Index	Gets the zero-based index of this table column within the ITableColumns collection. The index reflects the current position of the column in its parent ITable.
Name	Gets the name of the table column. This name is also used as the display name of the table column and must be unique within the table.
Range	Gets the IRange that represents this table column. The returned range covers the cells associated with the current ITableColumn within its parent table.
Total	Returns the Total row for the ITableColumn object (read-only).
TotalsCalculation	Gets the calculation type used in the Totals row of this table column. The returned TotalsCalculation value determines how the totals cell for the column is calculated when the table shows a totals row.

Methods

Name	Description
Delete()	Deletes this table column from its parent table.