Class ExcelPivotTable

Namespace

OfficeOpenXml.Table.PivotTable

Assembly

Magicodes.EPPlus.dll

public class ExcelPivotTable : XmlHelper

Inheritance

object

XmlHelper

ExcelPivotTable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

Address

public ExcelAddressBase Address { get; }

Property Value

ExcelAddressBase

ApplyBorderFormats

public bool ApplyBorderFormats { get; set; }

Property Value

bool

ApplyFontFormats

public bool ApplyFontFormats { get; set; }

Property Value

bool

ApplyNumberFormats

public bool ApplyNumberFormats { get; set; }

Property Value

bool

ApplyPatternFormats

public bool ApplyPatternFormats { get; set; }

Property Value

bool

ApplyWidthHeightFormats

public bool ApplyWidthHeightFormats { get; set; }

Property Value

bool

CacheDefinition

public ExcelPivotCacheDefinition CacheDefinition { get; }

Property Value

ExcelPivotCacheDefinition

ColumGrandTotals

[Obsolete("Use correctly spelled property 'ColumnGrandTotals'")]
public bool ColumGrandTotals { get; set; }

Property Value

bool

ColumnFields

public ExcelPivotTableRowColumnFieldCollection ColumnFields { get; }

Property Value

ExcelPivotTableRowColumnFieldCollection

ColumnGrandTotals

public bool ColumnGrandTotals { get; set; }

Property Value

bool

ColumnHeaderCaption

public string ColumnHeaderCaption { get; set; }

Property Value

string

Compact

public bool Compact { get; set; }

Property Value

bool

CompactData

public bool CompactData { get; set; }

Property Value

bool

DataCaption

public string DataCaption { get; set; }

Property Value

string

DataFields

public ExcelPivotTableDataFieldCollection DataFields { get; }

Property Value

ExcelPivotTableDataFieldCollection

DataOnRows

public bool DataOnRows { get; set; }

Property Value

bool

EnableDrill

public bool EnableDrill { get; set; }

Property Value

bool

ErrorCaption

public string ErrorCaption { get; set; }

Property Value

string

FieldPrintTitles

public bool FieldPrintTitles { get; set; }

Property Value

bool

Fields

public ExcelPivotTableFieldCollection Fields { get; }

Property Value

ExcelPivotTableFieldCollection

FirstDataCol

public int FirstDataCol { get; set; }

Property Value

int

FirstDataRow

public int FirstDataRow { get; set; }

Property Value

int

FirstHeaderRow

public int FirstHeaderRow { get; set; }

Property Value

int

GrandTotalCaption

public string GrandTotalCaption { get; set; }

Property Value

string

GridDropZones

public bool GridDropZones { get; set; }

Property Value

bool

Indent

public int Indent { get; set; }

Property Value

int

ItemPrintTitles

public bool ItemPrintTitles { get; set; }

Property Value

bool

MissingCaption

public string MissingCaption { get; set; }

Property Value

string

MultipleFieldFilters

public bool MultipleFieldFilters { get; set; }

Property Value

bool

Name

public string Name { get; set; }

Property Value

string

Outline

public bool Outline { get; set; }

Property Value

bool

OutlineData

public bool OutlineData { get; set; }

Property Value

bool

PageFields

public ExcelPivotTableRowColumnFieldCollection PageFields { get; }

Property Value

ExcelPivotTableRowColumnFieldCollection

PageWrap

public int PageWrap { get; set; }

Property Value

int

PivotTableUri

public Uri PivotTableUri { get; }

Property Value

Uri

PivotTableXml

public XmlDocument PivotTableXml { get; }

Property Value

XmlDocument

PrintDrill

public bool PrintDrill { get; set; }

Property Value

bool

RowFields

public ExcelPivotTableRowColumnFieldCollection RowFields { get; }

Property Value

ExcelPivotTableRowColumnFieldCollection

RowGrandTotals

public bool RowGrandTotals { get; set; }

Property Value

bool

RowHeaderCaption

public string RowHeaderCaption { get; set; }

Property Value

string

ShowCalcMember

public bool ShowCalcMember { get; set; }

Property Value

bool

ShowDataTips

public bool ShowDataTips { get; set; }

Property Value

bool

ShowDrill

public bool ShowDrill { get; set; }

Property Value

bool

ShowError

public bool ShowError { get; set; }

Property Value

bool

ShowHeaders

public bool ShowHeaders { get; set; }

Property Value

bool

ShowMemberPropertyTips

public bool ShowMemberPropertyTips { get; set; }

Property Value

bool

StyleName

public string StyleName { get; set; }

Property Value

string

TableStyle

public TableStyles TableStyle { get; set; }

Property Value

TableStyles

UseAutoFormatting

public bool UseAutoFormatting { get; set; }

Property Value

bool

WorkSheet

public ExcelWorksheet WorkSheet { get; set; }

Property Value

ExcelWorksheet