Class LoadFromCollectionParams

Parameters for the LoadFromCollection method

Inheritance
System.Object
LoadFunctionFunctionParamsBase
LoadFromCollectionParams
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.LoadFunctions.Params
Assembly: EPPlus.dll
Syntax
public class LoadFromCollectionParams : LoadFunctionFunctionParamsBase

Fields

DefaultBindingFlags

Default value for the BindingFlags property

Declaration
public const BindingFlags DefaultBindingFlags = BindingFlags.Instance | BindingFlags.Public
Field Value
Type Description
System.Reflection.BindingFlags

Properties

BindingFlags

The BindingFlags used when reading properties via reflection.

Declaration
public BindingFlags BindingFlags { get; set; }
Property Value
Type Description
System.Reflection.BindingFlags

HeaderParsingType

Sets how headers should be parsed before added to the worksheet, see HeaderParsingTypes

Declaration
public HeaderParsingTypes HeaderParsingType { get; set; }
Property Value
Type Description
HeaderParsingTypes

Members

If not null, this specifies the members that should be used. Any member not present will be ignored.

Declaration
public MemberInfo[] Members { get; set; }
Property Value
Type Description
System.Reflection.MemberInfo[]

Methods

RegisterDictionaryKeys(IEnumerable<String>)

Registers default keys for properties decorated with the OfficeOpenXml.Attributes.EPPlusDictionaryColumnAttribute. These will also be used to create the column for this property.

Declaration
public void RegisterDictionaryKeys(IEnumerable<string> keys)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<System.String> keys

The keys to register

RegisterDictionaryKeys(String, IEnumerable<String>)

Register keys to a property decorated with the OfficeOpenXml.Attributes.EPPlusDictionaryColumnAttribute. These will also be used to create the column for this property. The keyId should map to the OfficeOpenXml.Attributes.EPPlusDictionaryColumnAttribute.KeyId

Declaration
public void RegisterDictionaryKeys(string keyId, IEnumerable<string> keys)
Parameters
Type Name Description
System.String keyId

Key id used to store this set of keys
System.Collections.Generic.IEnumerable<System.String> keys

Keys for the

SetNumberFormatProvider(IExcelNumberFormatProvider)

Sets an IExcelNumberFormatProvider that will be used for setting NumberFormats in the range

Declaration
public void SetNumberFormatProvider(IExcelNumberFormatProvider numberFormatProvider)
Parameters
Type Name Description
IExcelNumberFormatProvider numberFormatProvider

The IExcelNumberFormatProvider to use
See Also