Interface IPivotTable

Namespace

Spire.Xls.Core

Assembly

Spire.XLS.dll

public interface IPivotTable

Properties

AutoFormatType

PivotAutoFomatTypes AutoFormatType { get; set; }

Property Value

PivotAutoFomatTypes

BuiltInStyle

PivotBuiltInStyles? BuiltInStyle { get; set; }

Property Value

PivotBuiltInStyles?

CacheIndex

int CacheIndex { get; }

Property Value

int

CalculatedFields

IPivotCalculatedFields CalculatedFields { get; }

Property Value

IPivotCalculatedFields

ColumnFields

IPivotFields ColumnFields { get; }

Property Value

IPivotFields

ColumnsPerPage

int ColumnsPerPage { get; }

Property Value

int

DataFields

PivotDataFields DataFields { get; }

Property Value

PivotDataFields

DisplayFieldCaptions

bool DisplayFieldCaptions { get; set; }

Property Value

bool

IsColumnGrand

bool IsColumnGrand { get; set; }

Property Value

bool

IsCompatibleWithExcel2003

bool IsCompatibleWithExcel2003 { get; set; }

Property Value

bool

IsRowGrand

bool IsRowGrand { get; set; }

Property Value

bool

Location

CellRange Location { get; set; }

Property Value

CellRange

Name

string Name { get; set; }

Property Value

string

Options

IPivotTableOptions Options { get; }

Property Value

IPivotTableOptions

PageFields

IPivotFields PageFields { get; }

Property Value

IPivotFields

PivotFields

PivotTableFields PivotFields { get; }

Property Value

PivotTableFields

RepeatItemsOnEachPrintedPage

bool RepeatItemsOnEachPrintedPage { get; set; }

Property Value

bool

RowFields

IPivotFields RowFields { get; }

Property Value

IPivotFields

RowsPerPage

int RowsPerPage { get; }

Property Value

int

ShowColumnGrand

bool ShowColumnGrand { get; set; }

Property Value

bool

ShowDataFieldInRow

bool ShowDataFieldInRow { get; set; }

Property Value

bool

ShowDrillIndicators

bool ShowDrillIndicators { get; set; }

Property Value

bool

ShowRowGrand

bool ShowRowGrand { get; set; }

Property Value

bool

Methods

ApplyStyleToRange(IXLSRange, CellStyle)

void ApplyStyleToRange(IXLSRange cellRange, CellStyle style)

Parameters

cellRange IXLSRange

style CellStyle

ChangeDataSource(IXLSRange)

void ChangeDataSource(IXLSRange dataSource)

Parameters

dataSource IXLSRange

Clear()

void Clear()

ClearColumnFieldFilter(string)

void ClearColumnFieldFilter(string fieldName)

Parameters

fieldName string

ClearFilter(string)

void ClearFilter(string fieldName)

Parameters

fieldName string

ClearRowFieldFilter(string)

void ClearRowFieldFilter(string fieldName)

Parameters

fieldName string