Class ExcelConnectionParameter

Represents a parameter for an Excel connection.

Inheritance

object

ExcelConnectionParameter

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 ExcelConnectionParameter

Properties

Boolean

Boolean value for the parameter.

Declaration

public bool? Boolean { get; set; }

Property Value

Type	Description
bool?

Cell

Cell reference for the parameter.

Declaration

public string Cell { get; set; }

Property Value

Type	Description
string

Double

Double value for the parameter.

Declaration

public double? Double { get; set; }

Property Value

Type	Description
double?

Integer

Integer value for the parameter.

Declaration

public int? Integer { get; set; }

Property Value

Type	Description
int?

Name

The name of the parameter.

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

ParameterType

The type of the parameter. Defaults to Prompt.

Declaration

public eConnectionParameterType ParameterType { get; set; }

Property Value

Type	Description
eConnectionParameterType

Prompt

Prompt text for the parameter.

Declaration

public string Prompt { get; set; }

Property Value

Type	Description
string

RefreshOnChange

Indicates whether to refresh on change. Defaults to false.

Declaration

public bool RefreshOnChange { get; set; }

Property Value

Type	Description
bool

SqlType

The SQL type of the parameter. Defaults to 0.

Declaration

public int SqlType { get; set; }

Property Value

Type	Description
int

String

String value for the parameter.

Declaration

public string String { get; set; }

Property Value

Type	Description
string