Class
PivotExportToExcelML

Definition

Namespace:Telerik.WinControls.UI.Export

Assembly:Telerik.WinControls.PivotGrid.dll

Syntax:

cs-api-definition
public class PivotExportToExcelML

Inheritance: objectPivotExportToExcelML

Constructors

PivotExportToExcelML(RadPivotGrid)

Declaration

cs-api-definition
public PivotExportToExcelML(RadPivotGrid pivotGrid)

Parameters

pivotGrid

RadPivotGrid

PivotExportToExcelML(RadPivotGridElement)

Declaration

cs-api-definition
public PivotExportToExcelML(RadPivotGridElement pivotGrid)

Parameters

pivotGrid

RadPivotGridElement

Properties

CellBackColor

Declaration

cs-api-definition
public Color CellBackColor { get; set; }

Property Value

Color

ColumnsLayoutType

Declaration

cs-api-definition
public PivotLayout ColumnsLayoutType { get; }

Property Value

PivotLayout

DataCellsFont

Declaration

cs-api-definition
public Font DataCellsFont { get; set; }

Property Value

Font

DescriptorsBackColor

Declaration

cs-api-definition
public Color DescriptorsBackColor { get; set; }

Property Value

Color

ExportFlatData

Declaration

cs-api-definition
public bool ExportFlatData { get; set; }

Property Value

bool

ExportSelectionOnly

Declaration

cs-api-definition
public bool ExportSelectionOnly { get; set; }

Property Value

bool

ExportVisualSettings

Declaration

cs-api-definition
public bool ExportVisualSettings { get; set; }

Property Value

bool

GrandTotalsBackColor

Declaration

cs-api-definition
public Color GrandTotalsBackColor { get; set; }

Property Value

Color

GridLinesColor

Declaration

cs-api-definition
public Color GridLinesColor { get; set; }

Property Value

Color

HeaderCellsFont

Declaration

cs-api-definition
public Font HeaderCellsFont { get; set; }

Property Value

Font

HeadersBackColor

Declaration

cs-api-definition
public Color HeadersBackColor { get; set; }

Property Value

Color

RowsLayoutType

Declaration

cs-api-definition
public PivotLayout RowsLayoutType { get; }

Property Value

PivotLayout

SheetMaxRows

Gets or sets the maximum number of rows per sheet.

Declaration

cs-api-definition
[CLSCompliant(false)]
public ExcelMaxRows SheetMaxRows { get; set; }

Property Value

ExcelMaxRows

The sheet max rows.

SheetName

Declaration

cs-api-definition
public string SheetName { get; set; }

Property Value

string

ShowGridLines

Declaration

cs-api-definition
public bool ShowGridLines { get; set; }

Property Value

bool

SubTotalsBackColor

Declaration

cs-api-definition
public Color SubTotalsBackColor { get; set; }

Property Value

Color

Methods

CallOnExportCellFormatting(object, ExcelPivotCellExportingEventArgs)

Declaration

cs-api-definition
public void CallOnExportCellFormatting(object sender, ExcelPivotCellExportingEventArgs e)

Parameters

sender

object

e

ExcelPivotCellExportingEventArgs

GetAggregateDescriptorCell(int)

Declaration

cs-api-definition
protected virtual RadPrintElement GetAggregateDescriptorCell(int aggregateIndex)

Parameters

aggregateIndex

int

Returns

RadPrintElement

GetColumnDescriptorCell(int)

Declaration

cs-api-definition
protected virtual RadPrintElement GetColumnDescriptorCell(int descriptorIndex)

Parameters

descriptorIndex

int

Returns

RadPrintElement

GetColumnHeaderCell(int, int)

Declaration

cs-api-definition
protected virtual RadPrintElement GetColumnHeaderCell(int rowIndex, int columnIndex)

Parameters

rowIndex

int

columnIndex

int

Returns

RadPrintElement

GetDataCell(int, int, PivotRowElement)

Declaration

cs-api-definition
protected virtual RadPrintElement GetDataCell(int rowIndex, int columnIndex, PivotRowElement visualRow)

Parameters

rowIndex

int

columnIndex

int

visualRow

PivotRowElement

Returns

RadPrintElement

GetPrintElementForCell(int, int, PivotRowElement)

Declaration

cs-api-definition
protected virtual RadPrintElement GetPrintElementForCell(int rowIndex, int columnIndex, PivotRowElement visualRow)

Parameters

rowIndex

int

columnIndex

int

visualRow

PivotRowElement

Returns

RadPrintElement

GetRowDescriptorCell(int)

Declaration

cs-api-definition
protected virtual RadPrintElement GetRowDescriptorCell(int descriptorIndex)

Parameters

descriptorIndex

int

Returns

RadPrintElement

GetRowHeaderCell(int, int)

Declaration

cs-api-definition
protected virtual RadPrintElement GetRowHeaderCell(int rowIndex, int columnIndex)

Parameters

rowIndex

int

columnIndex

int

Returns

RadPrintElement

OnExcelTableCreated(ExcelTableCreatedEventArgs)

Raises the event.

Declaration

cs-api-definition
[CLSCompliant(false)]
protected virtual void OnExcelTableCreated(ExcelTableCreatedEventArgs e)

Parameters

e

ExcelTableCreatedEventArgs

The ExcelTableCreatedEventArgs instance containing the event data.

RunExport(string)

Creates ExcelML file

Declaration

cs-api-definition
public void RunExport(string fileName)

Parameters

fileName

string

Export file name

Events

ExcelTableCreated

Occurs when the excel table is created.

Declaration

cs-api-definition
[CLSCompliant(false)]
public event ExcelTableCreatedEventHandler ExcelTableCreated

Event Value

ExcelTableCreatedEventHandler

PivotExcelCellFormatting

Declaration

cs-api-definition
public event PivotExcelCellFormattingEvent PivotExcelCellFormatting

Event Value

PivotExcelCellFormattingEvent