Class LoadFromCollectionParams

Namespace

OfficeOpenXml.LoadFunctions.Params

Assembly

EPPlus.dll

Parameters for the LoadFromCollection method

public class LoadFromCollectionParams : LoadFunctionFunctionParamsBase

Inheritance

object

LoadFunctionFunctionParamsBase

LoadFromCollectionParams

Inherited Members

LoadFunctionFunctionParamsBase.PrintHeaders

LoadFunctionFunctionParamsBase.TableName

LoadFunctionFunctionParamsBase.TableStyle

LoadFunctionFunctionParamsBase.UseBuiltInStylesForHyperlinks

LoadFunctionFunctionParamsBase.Transpose

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

LoadFromCollectionParams()

public LoadFromCollectionParams()

Fields

DefaultBindingFlags

Default value for the BindingFlags property

public const BindingFlags DefaultBindingFlags = Instance | Public

Field Value

BindingFlags

Properties

BindingFlags

The BindingFlags used when reading properties via reflection.

public BindingFlags BindingFlags { get; set; }

Property Value

BindingFlags

HeaderParsingType

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

public HeaderParsingTypes HeaderParsingType { get; set; }

Property Value

HeaderParsingTypes

Members

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

public MemberInfo[] Members { get; set; }

Property Value

MemberInfo[]

Methods

RegisterDictionaryKeys(IEnumerable<string>)

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

public void RegisterDictionaryKeys(IEnumerable<string> keys)

Parameters

keys IEnumerable<string>

The keys to register

RegisterDictionaryKeys(string, IEnumerable<string>)

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

public void RegisterDictionaryKeys(string keyId, IEnumerable<string> keys)

Parameters

keyId string

Key id used to store this set of keys

keys IEnumerable<string>

Keys for the

SetNumberFormatProvider(IExcelNumberFormatProvider)

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

public void SetNumberFormatProvider(IExcelNumberFormatProvider numberFormatProvider)

Parameters

numberFormatProvider IExcelNumberFormatProvider

The IExcelNumberFormatProvider to use

See Also

NumberFormatId