Class ExcelConnectionOlapProperties

Olap specific properties for the connection.

Inheritance

object

ExcelConnectionOlapProperties

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Data.Connection

Assembly: EPPlus.dll

Syntax

public class 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."/>

Declaration

public string DataModelCommand { get; }

Property Value

Type	Description
string

Local

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

Declaration

public bool Local { get; set; }

Property Value

Type	Description
bool

LocalConnection

The local connection string used when Local is true.

Declaration

public string LocalConnection { get; set; }

Property Value

Type	Description
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.

Declaration

public bool LocalRefresh { get; set; }

Property Value

Type	Description
bool

RowDrillCount

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

Declaration

public int? RowDrillCount { get; set; }

Property Value

Type	Description
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.

Declaration

public bool SendLocale { get; set; }

Property Value

Type	Description
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.

Declaration

public bool ServerFill { get; set; }

Property Value

Type	Description
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.

Declaration

public bool ServerFont { get; set; }

Property Value

Type	Description
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.

Declaration

public bool ServerFontColor { get; set; }

Property Value

Type	Description
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.

Declaration

public bool ServerNumberFormat { get; set; }

Property Value

Type	Description
bool

Tables

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

Declaration

public List<string> Tables { get; }

Property Value

Type	Description
List<string>