Show / Hide Table of Contents

Class EpplusTableAttribute

Attribute used by LoadFromCollection<T>(IEnumerable<T>) to configure parameters for the functions/>

Inheritance
System.Object
System.Attribute
EpplusTableAttribute
Inherited Members
System.Attribute.Equals(System.Object)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttribute(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Module)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Boolean)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type)
System.Attribute.GetCustomAttributes(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.GetHashCode()
System.Attribute.IsDefaultAttribute()
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type)
System.Attribute.IsDefined(System.Reflection.Assembly, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.MemberInfo, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.Module, System.Type)
System.Attribute.IsDefined(System.Reflection.Module, System.Type, System.Boolean)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type)
System.Attribute.IsDefined(System.Reflection.ParameterInfo, System.Type, System.Boolean)
System.Attribute.Match(System.Object)
System.Attribute.TypeId
System.Object.Equals(System.Object, System.Object)
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Attributes
Assembly: EPPlus.dll
Syntax
[AttributeUsage(AttributeTargets.Class | AttributeTargets.Interface)]
public class EpplusTableAttribute : Attribute

Constructors

EpplusTableAttribute()

Constructor

Declaration
public EpplusTableAttribute()

Properties

AutoCalculate

If true, EPPlus will calculate the table range when the data has been read into the spreadsheet and store the results in the Value property of each cell.

Declaration
public bool AutoCalculate { get; set; }
Property Value
Type Description
System.Boolean

AutofitColumns

If true, column width will be adjusted to cell content

Declaration
public bool AutofitColumns { get; set; }
Property Value
Type Description
System.Boolean

NumberFormatProviderType

If set, this System.Type must be implementing the IExcelNumberFormatProvider interface. If not an Exception will be thrown. Note that the implementing type must have an empty constructor.

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

PrintHeaders

If true, there will be a header row with column names over the data

Declaration
public bool PrintHeaders { get; set; }
Property Value
Type Description
System.Boolean

ShowFirstColumn

If true, the first column of the table is highlighted

Declaration
public bool ShowFirstColumn { get; set; }
Property Value
Type Description
System.Boolean

ShowLastColumn

If true, the last column of the table is highlighted

Declaration
public bool ShowLastColumn { get; set; }
Property Value
Type Description
System.Boolean

ShowTotal

If true, a totals row will be added under the table data. This should be used in combination with TotalsRowFunction on the column attributes.

Declaration
public bool ShowTotal { get; set; }
Property Value
Type Description
System.Boolean

TableStyle

Table style

Declaration
public TableStyles TableStyle { get; set; }
Property Value
Type Description
TableStyles
In This Article
Back to top Generated by DocFX