Class ExcelPowerQueryMetaDataEntry¶

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

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

public class ExcelPowerQueryMetaDataEntry

Constructors¶

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

public ExcelPowerQueryMetaDataEntry(string type, object value, bool ignoreUnknownEntries = true, bool validateDataTypeForKnownEntries = true)

type string

The Entry type.

value object

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

ignoreUnknownEntries bool

If true(default), EPPlus will ignore and preserve values not present in the ValidEntries dictionary

validateDataTypeForKnownEntries bool

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.

public static readonly Dictionary<string, string> ValidEntries

The entry type. Please see ValidEntries for valid entries.

public string EntryType { get; }

The value for the entry.

public object Value { get; }

Get the value formatted according to the supplied culture.

public string GetValueAsText(CultureInfo culture)

Return the object as a string.

public override string ToString()