Class LoadFromCollectionParams

Parameters for the LoadFromCollection method

Inheritance
object
LoadFunctionFunctionParamsBase
LoadFromCollectionParams
Inherited Members
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 = Instance | Public
Field Value
Type Description
BindingFlags

Properties

BindingFlags

The BindingFlags used when reading properties via reflection.

Declaration
public BindingFlags BindingFlags { get; set; }
Property Value
Type Description
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
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
IEnumerable<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 KeyId property of the attribute.

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

Key id used to store this set of keys
IEnumerable<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