Documentation

Class PivotExportToExcelML

Inheritance
System.Object
PivotExportToExcelML
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.WinControls.UI.Export
Assembly: Telerik.WinControls.PivotGrid.dll

Syntax

public class PivotExportToExcelML

Constructors

PivotExportToExcelML(RadPivotGrid)

Declaration
public PivotExportToExcelML(RadPivotGrid pivotGrid)
Parameters
RadPivotGrid pivotGrid

PivotExportToExcelML(RadPivotGridElement)

Declaration
public PivotExportToExcelML(RadPivotGridElement pivotGrid)
Parameters
RadPivotGridElement pivotGrid

Properties

CellBackColor

Declaration
public Color CellBackColor { get; set; }
Property Value
System.Drawing.Color

ColumnsLayoutType

Declaration
public PivotLayout ColumnsLayoutType { get; }
Property Value
PivotLayout

DataCellsFont

Declaration
public Font DataCellsFont { get; set; }
Property Value
System.Drawing.Font

DescriptorsBackColor

Declaration
public Color DescriptorsBackColor { get; set; }
Property Value
System.Drawing.Color

ExportFlatData

Declaration
public bool ExportFlatData { get; set; }
Property Value
System.Boolean

ExportSelectionOnly

Declaration
public bool ExportSelectionOnly { get; set; }
Property Value
System.Boolean

ExportVisualSettings

Declaration
public bool ExportVisualSettings { get; set; }
Property Value
System.Boolean

GrandTotalsBackColor

Declaration
public Color GrandTotalsBackColor { get; set; }
Property Value
System.Drawing.Color

GridLinesColor

Declaration
public Color GridLinesColor { get; set; }
Property Value
System.Drawing.Color

HeaderCellsFont

Declaration
public Font HeaderCellsFont { get; set; }
Property Value
System.Drawing.Font

HeadersBackColor

Declaration
public Color HeadersBackColor { get; set; }
Property Value
System.Drawing.Color

LayoutType

Declaration
public PivotLayout LayoutType { get; }
Property Value
PivotLayout

RowsLayoutType

Declaration
public PivotLayout RowsLayoutType { get; }
Property Value
PivotLayout

SheetMaxRows

Gets or sets the maximum number of rows per sheet.

Declaration
[CLSCompliant(false)]
public ExcelMaxRows SheetMaxRows { get; set; }
Property Value
ExcelMaxRows

The sheet max rows.

SheetName

Declaration
public string SheetName { get; set; }
Property Value
System.String

ShowGridLines

Declaration
public bool ShowGridLines { get; set; }
Property Value
System.Boolean

SubTotalsBackColor

Declaration
public Color SubTotalsBackColor { get; set; }
Property Value
System.Drawing.Color

Methods

CallOnExportCellFormatting(Object, ExcelPivotCellExportingEventArgs)

Declaration
public void CallOnExportCellFormatting(object sender, ExcelPivotCellExportingEventArgs e)
Parameters
System.Object sender

ExcelPivotCellExportingEventArgs e

GetAggregateDescriptorCell(Int32)

Declaration
protected virtual RadPrintElement GetAggregateDescriptorCell(int aggregateIndex)
Parameters
System.Int32 aggregateIndex

Returns
RadPrintElement

GetColumnDescriptorCell(Int32)

Declaration
protected virtual RadPrintElement GetColumnDescriptorCell(int descriptorIndex)
Parameters
System.Int32 descriptorIndex

Returns
RadPrintElement

GetColumnHeaderCell(Int32, Int32)

Declaration
protected virtual RadPrintElement GetColumnHeaderCell(int rowIndex, int columnIndex)
Parameters
System.Int32 rowIndex

System.Int32 columnIndex

Returns
RadPrintElement

GetDataCell(Int32, Int32, PivotRowElement)

Declaration
protected virtual RadPrintElement GetDataCell(int rowIndex, int columnIndex, PivotRowElement visualRow)
Parameters
System.Int32 rowIndex

System.Int32 columnIndex

PivotRowElement visualRow

Returns
RadPrintElement

GetPrintElementForCell(Int32, Int32, PivotRowElement)

Declaration
protected virtual RadPrintElement GetPrintElementForCell(int rowIndex, int columnIndex, PivotRowElement visualRow)
Parameters
System.Int32 rowIndex

System.Int32 columnIndex

PivotRowElement visualRow

Returns
RadPrintElement

GetRowDescriptorCell(Int32)

Declaration
protected virtual RadPrintElement GetRowDescriptorCell(int descriptorIndex)
Parameters
System.Int32 descriptorIndex

Returns
RadPrintElement

GetRowHeaderCell(Int32, Int32)

Declaration
protected virtual RadPrintElement GetRowHeaderCell(int rowIndex, int columnIndex)
Parameters
System.Int32 rowIndex

System.Int32 columnIndex

Returns
RadPrintElement

OnExcelTableCreated(ExcelTableCreatedEventArgs)

Raises the ExcelTableCreated event.

Declaration
[CLSCompliant(false)]
protected virtual void OnExcelTableCreated(ExcelTableCreatedEventArgs e)
Parameters
ExcelTableCreatedEventArgs e

The ExcelTableCreatedEventArgs instance containing the event data.

RunExport(String)

Creates ExcelML file

Declaration
public void RunExport(string fileName)
Parameters
System.String fileName

Export file name

Events

ExcelTableCreated

Occurs when the excel table is created.

Declaration
[CLSCompliant(false)]
public event ExcelTableCreatedEventHandler ExcelTableCreated
Event Type
ExcelTableCreatedEventHandler

PivotExcelCellFormatting

Declaration
public event PivotExcelCellFormattingEvent PivotExcelCellFormatting
Event Type
PivotExcelCellFormattingEvent

Extension Methods