Class ExcelQueryTableField

Represents a query table field

Inheritance

object

ExcelQueryTableField

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Data.QueryTable

Assembly: EPPlus.dll

Syntax

public class ExcelQueryTableField

Properties

ClippedColumn

If this field/column is currently clipped and thus not visible in the worksheet. This state might occur for example when a query table is defined near the edge of a worksheet or other object in the spreadsheet that can't be overwritten with external data. In this case some of the fields are displayed, but not all of them.

Declaration

public bool ClippedColumn { get; set; }

Property Value

Type	Description
bool

DataBoundColumn

If this column is a user-defined column or comes from the external data query. User defined columns shall be preserved during data refresh operations. User defined columns are only supported on query tables that are attached to table objects

Declaration

public bool DataBoundColumn { get; set; }

Property Value

Type	Description
bool

FillFormulaOnRefresh

If the formula in this field/column should be filled down on data refresh.

Declaration

public bool FillFormulaOnRefresh { get; set; }

Property Value

Type	Description
bool

Id

A unique Id for the field

Declaration

public int Id { get; }

Property Value

Type	Description
int

Name

A name for the field.

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

RowNumbers

If this column contains the row numbers for the records returned.

Declaration

public bool RowNumbers { get; set; }

Property Value

Type	Description
bool

TableColumnId

The index of the column in the table.

Declaration

public int TableColumnId { get; }

Property Value

Type	Description
int