Class ExcelConnectionParameter¶

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

Represents a parameter for an Excel connection.

public class ExcelConnectionParameter

Inheritance¶

object ← ExcelConnectionParameter

Inherited Members¶

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

Constructors¶

ExcelConnectionParameter()¶

public ExcelConnectionParameter()

Properties¶

Boolean¶

Boolean value for the parameter.

public bool? Boolean { get; set; }

Property Value¶

bool?

Cell¶

Cell reference for the parameter.

public string Cell { get; set; }

Property Value¶

string

Double¶

Double value for the parameter.

public double? Double { get; set; }

Property Value¶

double?

Integer¶

Integer value for the parameter.

public int? Integer { get; set; }

Property Value¶

int?

Name¶

The name of the parameter.

public string Name { get; set; }

Property Value¶

string

ParameterType¶

The type of the parameter. Defaults to Prompt.

public eConnectionParameterType ParameterType { get; set; }

Property Value¶

eConnectionParameterType

Prompt¶

Prompt text for the parameter.

public string Prompt { get; set; }

Property Value¶

string

RefreshOnChange¶

Indicates whether to refresh on change. Defaults to false.

public bool RefreshOnChange { get; set; }

Property Value¶

bool

SqlType¶

The SQL type of the parameter. Defaults to 0.

public int SqlType { get; set; }

Property Value¶

int

String¶

String value for the parameter.

public string String { get; set; }

Property Value¶

string