Class ExcelQueryTableField¶

Namespace: OfficeOpenXml.Data.QueryTable
Assembly: EPPlus.dll

Represents a query table field

public class ExcelQueryTableField

Inheritance¶

object ← ExcelQueryTableField

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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.

public bool ClippedColumn { get; set; }

Property Value¶

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

public bool DataBoundColumn { get; set; }

Property Value¶

bool

FillFormulaOnRefresh¶

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

public bool FillFormulaOnRefresh { get; set; }

Property Value¶

bool

Id¶

A unique Id for the field

public int Id { get; }

Property Value¶

int

Name¶

A name for the field.

public string Name { get; set; }

Property Value¶

string

RowNumbers¶

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

public bool RowNumbers { get; set; }

Property Value¶

bool

TableColumnId¶

The index of the column in the table.

public int TableColumnId { get; }

Property Value¶

int