Class ExcelPowerQueryMetaDataEntry

An entity in the meta data entity collection for Power Query.

Inheritance
object
ExcelPowerQueryMetaDataEntry
Inherited Members
Namespace: OfficeOpenXml.Data.Connection
Assembly: EPPlus.dll
Syntax
public class ExcelPowerQueryMetaDataEntry

Constructors

ExcelPowerQueryMetaDataEntry(string, object, bool, bool)

Create a new ExcelPowerQueryMetaDataEntry validating the type and value according to the ValidEntries

Declaration
public ExcelPowerQueryMetaDataEntry(string type, object value, bool ignoreUnknownEntries = true, bool validateDataTypeForKnownEntries = true)
Parameters
Type Name Description
string type

The Entry type.
object value

The value of the Entry. This value must be of type, string, integer, bool, datetime or double.
bool ignoreUnknownEntries

If true(default), EPPlus will ignore and preserve values not present in the ValidEntries dictionary
bool validateDataTypeForKnownEntries
Exceptions
Type Condition
ArgumentException

Fields

ValidEntries

The valid entries and there data types. Data Types can be b=bool, s=string, i=integer, d=date/time and f=double. Entry types are case-sensitive.

Declaration
public static readonly Dictionary<string, string> ValidEntries
Field Value
Type Description
Dictionary<string, string>

Properties

EntryType

The entry type. Please see ValidEntries for valid entries.

Declaration
public string EntryType { get; }
Property Value
Type Description
string

Value

The value for the entry.

Declaration
public object Value { get; }
Property Value
Type Description
object

Methods

GetValueAsText(CultureInfo)

Get the value formatted according to the supplied culture.

Declaration
public string GetValueAsText(CultureInfo culture)
Parameters
Type Name Description
CultureInfo culture
Returns
Type Description
string

ToString()

Return the object as a string.

Declaration
public override string ToString()
Returns
Type Description
string
Overrides