Table of Contents

Class EpplusTableAttribute

Namespace
OfficeOpenXml.Attributes
Assembly
EPPlus.dll

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

[AttributeUsage(AttributeTargets.Class|AttributeTargets.Interface)]
public class EpplusTableAttribute : Attribute
Inheritance
EpplusTableAttribute
Inherited Members

Constructors

EpplusTableAttribute()

Constructor

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.

public bool AutoCalculate { get; set; }

Property Value

bool

AutofitColumns

If true, column width will be adjusted to cell content

public bool AutofitColumns { get; set; }

Property Value

bool

NumberFormatProviderType

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

public Type NumberFormatProviderType { get; set; }

Property Value

Type

PrintHeaders

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

public bool PrintHeaders { get; set; }

Property Value

bool

ShowFirstColumn

If true, the first column of the table is highlighted

public bool ShowFirstColumn { get; set; }

Property Value

bool

ShowLastColumn

If true, the last column of the table is highlighted

public bool ShowLastColumn { get; set; }

Property Value

bool

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.

public bool ShowTotal { get; set; }

Property Value

bool

TableStyle

Table style

public TableStyles TableStyle { get; set; }

Property Value

TableStyles