New to Telerik UI for WinForms? Start a free 30-day trial

Definition

Namespace:Telerik.WinControls.UI.Export

Assembly:Telerik.WinControls.PivotGrid.dll

Syntax:

C#
public class PivotExportToExcelML

Inheritance: objectPivotExportToExcelML

Constructors

C#
public PivotExportToExcelML(RadPivotGrid pivotGrid)
Parameters:pivotGridRadPivotGrid
C#
public PivotExportToExcelML(RadPivotGridElement pivotGrid)
Parameters:pivotGridRadPivotGridElement

Properties

C#
public Color CellBackColor { get; set; }
C#
public PivotLayout ColumnsLayoutType { get; }
C#
public Font DataCellsFont { get; set; }
C#
public Color DescriptorsBackColor { get; set; }
C#
public bool ExportFlatData { get; set; }
C#
public bool ExportSelectionOnly { get; set; }
C#
public bool ExportVisualSettings { get; set; }
C#
public Color GrandTotalsBackColor { get; set; }
C#
public Color GridLinesColor { get; set; }
C#
public Font HeaderCellsFont { get; set; }
C#
public Color HeadersBackColor { get; set; }
C#
public PivotLayout RowsLayoutType { get; }

Gets or sets the maximum number of rows per sheet.

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

The sheet max rows.

C#
public string SheetName { get; set; }
C#
public bool ShowGridLines { get; set; }
C#
public Color SubTotalsBackColor { get; set; }

Methods

C#
public void CallOnExportCellFormatting(object sender, ExcelPivotCellExportingEventArgs e)
Parameters:senderobjecteExcelPivotCellExportingEventArgs
C#
protected virtual RadPrintElement GetAggregateDescriptorCell(int aggregateIndex)
Parameters:aggregateIndexintReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetColumnDescriptorCell(int descriptorIndex)
Parameters:descriptorIndexintReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetColumnHeaderCell(int rowIndex, int columnIndex)
Parameters:rowIndexintcolumnIndexintReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetDataCell(int rowIndex, int columnIndex, PivotRowElement visualRow)
Parameters:rowIndexintcolumnIndexintvisualRowPivotRowElementReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetPrintElementForCell(int rowIndex, int columnIndex, PivotRowElement visualRow)
Parameters:rowIndexintcolumnIndexintvisualRowPivotRowElementReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetRowDescriptorCell(int descriptorIndex)
Parameters:descriptorIndexintReturns:

RadPrintElement

C#
protected virtual RadPrintElement GetRowHeaderCell(int rowIndex, int columnIndex)
Parameters:rowIndexintcolumnIndexintReturns:

RadPrintElement

Raises the event.

C#
[CLSCompliant(false)]
protected virtual void OnExcelTableCreated(ExcelTableCreatedEventArgs e)
Parameters:eExcelTableCreatedEventArgs

The ExcelTableCreatedEventArgs instance containing the event data.

Creates ExcelML file

C#
public void RunExport(string fileName)
Parameters:fileNamestring

Export file name

Events

Occurs when the excel table is created.

C#
[CLSCompliant(false)]
public event ExcelTableCreatedEventHandler ExcelTableCreated
C#
public event PivotExcelCellFormattingEvent PivotExcelCellFormatting