ExportToExcelML
Definition
Namespace:Telerik.WinControls.UI.Export
Assembly:TelerikData.dll
Syntax:
public class ExportToExcelML : IExportGridToInheritance: objectExportToExcelML
Implements:
Constructors
Properties
Gets or sets the child view export mode.
public ChildViewExportMode ChildViewExportMode { get; set; }The child view export mode.
Gets or sets the encoding used for the exported file. Default encoding is UTF8.
public Encoding Encoding { get; set; }Set if child rows should be exported.
public bool ExportHierarchy { set; }Sets a value indicating whether the visual settings should be exported.
public bool ExportVisualSettings { set; }true if visual settings are exported; otherwise, false.
Sets the file extension of the exported file.
public string FileExtension { set; }The file extension.
Implements:
Sets a value indicating how hidden columns are exported.
public HiddenOption HiddenColumnOption { set; }The hidden column option.
Implements:
Sets a value indicating how hidden rows are exported.
public HiddenOption HiddenRowOption { set; }The hidden row option.
Implements:
Sets a value indicating how the export behavies when paging is enabled.
public PagingExportOption PagingExportOption { set; }The paging export option.
Sets the RadGridView to export.
public RadGridView RadGridViewToExport { set; }The RadGridView to export.
Implements:
Sets the sheet max rows.
public ExcelMaxRows SheetMaxRows { set; }The sheet max rows.
Sets the name of the sheet.
public string SheetName { set; }The name of the sheet.
Sets a value indicating how summary rows are exported.
public SummariesOption SummariesExportOption { set; }The summaries export option.
Implements:
Methods
Add custom row in the provided excel table element
public SingleStyleElement AddCustomExcelRow(TableElement excelTableElement, int rowHeight, params object[] cellValues)Excel table element where the new row will be added
rowHeightintCustom row height in pixels. If 0 than the height has default value
cellValuesobject[]Values for the every excel cell in the custom row
Returns:New row's style element for further formatting
Raises the event.
protected virtual void OnChildViewExporting(ChildViewExportingEventArgs e)The ChildViewExportingEventArgs instance containing the event data.
Raises the event.
protected virtual void OnExcelCellFormatting(ExcelCellFormattingEventArgs e)The ExcelCellFormattingEventArgs instance containing the event data.
Raises the event.
protected virtual void OnExcelCellFormatting(ExcelRowFormattingEventArgs e)The ExcelRowFormattingEventArgs instance containing the event data.
Raises the event.
protected virtual void OnExcelTableCreated(ExcelTableCreatedEventArgs e)The ExcelTableCreatedEventArgs instance containing the event data.
Creates ExcelML file
Events
Occurs when a child view will be exported.
public event ChildViewExportingEventHandler ChildViewExportingOccurs for every cell that is being exported.
public event ExcelCellFormattingEventHandler ExcelCellFormattingOccurs for every row that is being exported.
public event ExcelRowFormattingEventHandler ExcelRowFormattingOccurs when the excel table is created.
public event ExcelTableCreatedEventHandler ExcelTableCreated