Class EpplusTableAttribute¶

Namespace: OfficeOpenXml.Attributes
Assembly: EPPlus.dll

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

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

Inheritance¶

object ← Attribute ← 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