Class ExcelConnectionOlapProperties¶

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

Olap specific properties for the connection.

public class ExcelConnectionOlapProperties

Inheritance¶

object ← ExcelConnectionOlapProperties

Inherited Members¶

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

Constructors¶

ExcelConnectionOlapProperties()¶

public ExcelConnectionOlapProperties()

Properties¶

DataModelCommand¶

The OLE DB command text that is used by a Model Data Source OLE DB. This property only applies when Type is set to DataModelOLEDB."/>

public string DataModelCommand { get; }

Property Value¶

string

Local¶

Indicates if we should get data from the local cube on refresh versus the original data source.

public bool Local { get; set; }

Property Value¶

bool

LocalConnection¶

The local connection string used when Local is true.

public string LocalConnection { get; set; }

Property Value¶

string

LocalRefresh¶

If we should refresh the local cube from the original data source. When true, the original OLAP data source is queried each time the user explicitly refreshes the data in the application, and a new local cube is constructed from this query.

public bool LocalRefresh { get; set; }

Property Value¶

bool

RowDrillCount¶

Maximum number of drill-through rows to return when the user drills through an aggregate value in a PivotTable.

public int? RowDrillCount { get; set; }

Property Value¶

int?

SendLocale¶

If true, the spreadsheet app should send the user interface locale ID to the OLAP provider to retrieve localized member names and properties, etc. When false, no locale ID is expected.

public bool SendLocale { get; set; }

Property Value¶

bool

ServerFill¶

When true a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source if this information is available.When false, OLAP server background fill colors are ignored, and standard formatting rules within the worksheet are followed.

public bool ServerFill { get; set; }

Property Value¶

bool

ServerFont¶

When true, a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font from the OLAP source. When false, formatting rules within the worksheet are followed.

public bool ServerFont { get; set; }

Property Value¶

bool

ServerFontColor¶

When true a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font color from the OLAP source.When false standard formatting rules within the worksheet are followed.

public bool ServerFontColor { get; set; }

Property Value¶

bool

ServerNumberFormat¶

When true a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the number format from the OLAP source.When false standard formatting rules within the worksheet are followed.

public bool ServerNumberFormat { get; set; }

Property Value¶

bool

Tables¶

A list of tables used in the data model for the connection. This property only applies when Type is set to DataModelOLEDB."/>

public List<string> Tables { get; }

Property Value¶

List<string>