Class PropertyGridSpreadExport

PropertyGridSpreadExport is a powerful exporting API, allowing to export RadPropertyGrid to XLSX, PDF, CSV, and TXT format, utilizing the Document Processing Libraries.

Inheritance

System.Object

PropertyGridSpreadExport

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.Export

Assembly: Telerik.WinControls.UI.dll

Syntax

public class PropertyGridSpreadExport

Constructors

PropertyGridSpreadExport(RadPropertyGrid)

Initializes a new instance of the PropertyGridSpreadExport class.

Declaration

public PropertyGridSpreadExport(RadPropertyGrid radPropertyGrid)

Parameters

RadPropertyGrid radPropertyGrid The RadPropertyGrid to export.

PropertyGridSpreadExport(RadPropertyGrid, SpreadExportFormat)

Initializes a new instance of the PropertyGridSpreadExport class.

Declaration

public PropertyGridSpreadExport(RadPropertyGrid radPropertyGrid, SpreadExportFormat exportFormat)

Parameters

RadPropertyGrid radPropertyGrid The RadPropertyGrid to export.

SpreadExportFormat exportFormat The export format.

Properties

CollapsedItemOption

Gets or sets a value indicating how children of collapsed items are exported.

Declaration

public HiddenOption CollapsedItemOption { get; set; }

Property Value

HiddenOption

ExportChildItemsGrouped

Gets or sets a value indicating whether to export child items grouped.

Declaration

public bool ExportChildItemsGrouped { get; set; }

Property Value

System.Boolean

ExportDescriptions

Gets or sets a value indicating whether to export item descriptions.

Declaration

public bool ExportDescriptions { get; set; }

Property Value

System.Boolean

ExportFormat

Gets or sets the format of the exported file - XLSX, PDF, CSV, TXT or XLS.

Declaration

public SpreadExportFormat ExportFormat { get; set; }

Property Value

SpreadExportFormat The file extension.

ExportVisualSettings

Gets or sets a value indicating whether the visual settings should be exported.

Declaration

public bool ExportVisualSettings { get; set; }

Property Value

System.Boolean true if visual settings are exported; otherwise, false.

FileExportMode

Specifies how the file will be exported: as a new file, a new sheet in existing file or will override a sheet with given name.

Declaration

public FileExportMode FileExportMode { get; set; }

Property Value

FileExportMode NewSheetInExistingFile - will add a new sheet to the specified file, if it exists CreateOrOverrideFile - will create/override the specified file CreateOrOverrideSheet - will create/override the specified sheet

ItemIndent

Gets or sets the indent of child items.

Declaration

public int ItemIndent { get; set; }

Property Value

System.Int32

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

Gets or sets the name of the sheet.

Declaration

public string SheetName { get; set; }

Property Value

System.String The name of the sheet.

Methods

CancelExportAsync()

Cancels an asynchronous export operation.

Declaration

public void CancelExportAsync()

ConvertImageToByteArray(Image)

Declaration

protected virtual byte[] ConvertImageToByteArray(Image image)

Parameters

System.Drawing.Image image

Returns

System.Byte[]

CreateCell(PropertyGridSpreadExportCell, Int32, Int32)

Declaration

protected virtual void CreateCell(PropertyGridSpreadExportCell cell, int currentRowIndex, int currentColumnIndex)

Parameters

PropertyGridSpreadExportCell cell

System.Int32 currentRowIndex

System.Int32 currentColumnIndex

GetBordersFromVisualCell(PropertyGridSpreadExportCell, LightVisualElement)

Declaration

protected virtual void GetBordersFromVisualCell(PropertyGridSpreadExportCell cell, LightVisualElement visualCell)

Parameters

PropertyGridSpreadExportCell cell

LightVisualElement visualCell

GetStylesFromVisualCell(PropertyGridSpreadExportCell, LightVisualElement)

Declaration

protected virtual void GetStylesFromVisualCell(PropertyGridSpreadExportCell cell, LightVisualElement visualCell)

Parameters

PropertyGridSpreadExportCell cell

LightVisualElement visualCell

OnAsyncExportCompleted(AsyncCompletedEventArgs)

Raises the AsyncExportCompleted event.

Declaration

protected virtual void OnAsyncExportCompleted(AsyncCompletedEventArgs e)

Parameters

System.ComponentModel.AsyncCompletedEventArgs e The System.ComponentModel.AsyncCompletedEventArgs instance containing the event data.

OnAsyncExportProgressChanged(ProgressChangedEventArgs)

Raises the AsyncExportProgressChanged event.

Declaration

protected virtual void OnAsyncExportProgressChanged(ProgressChangedEventArgs e)

Parameters

System.ComponentModel.ProgressChangedEventArgs e The System.ComponentModel.ProgressChangedEventArgs instance containing the event data.

OnCellFormatting(PropertyGridSpreadExportCellFormattingEventArgs)

Raises the CellFormatting event.

Declaration

protected virtual void OnCellFormatting(PropertyGridSpreadExportCellFormattingEventArgs e)

Parameters

PropertyGridSpreadExportCellFormattingEventArgs e The PropertyGridSpreadExportCellFormattingEventArgs instance containing the event data.

OnExportCompleted(EventArgs)

Raises the ExportCompleted event.

Declaration

protected virtual void OnExportCompleted(EventArgs e)

Parameters

System.EventArgs e The System.EventArgs instance containing the event data.

RunExport(Stream, ISpreadExportRenderer)

Starts an export operation.

Declaration

public void RunExport(Stream exportStream, ISpreadExportRenderer exportRenderer)

Parameters

System.IO.Stream exportStream The stream where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

RunExport(Stream, ISpreadExportRenderer, String)

Starts an export operation, in the specified sheet. If such sheet does not exist, it gets created.

Declaration

public void RunExport(Stream exportStream, ISpreadExportRenderer exportRenderer, string sheetName)

Parameters

System.IO.Stream exportStream The stream where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

System.String sheetName Name of the sheet.

RunExport(String, ISpreadExportRenderer)

Starts an export operation.

Declaration

public void RunExport(string fileName, ISpreadExportRenderer exportRenderer)

Parameters

System.String fileName The file name where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

RunExport(String, ISpreadExportRenderer, String)

Starts an export operation, in the specified sheet. If such sheet does not exist, it gets created.

Declaration

public void RunExport(string fileName, ISpreadExportRenderer exportRenderer, string sheetName)

Parameters

System.String fileName The file name where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

System.String sheetName Name of the sheet.

RunExportAsync(Stream, ISpreadExportRenderer)

Starts an export operation that runs in a background thread. Note that if ExportVisualSettings is true, collecting the visual styles from the RadPropertyGrid will still execute on the UI thread.

Declaration

public void RunExportAsync(Stream exportStream, ISpreadExportRenderer exportRenderer)

Parameters

System.IO.Stream exportStream The stream where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

RunExportAsync(Stream, ISpreadExportRenderer, String)

Starts an async export operation, in the specified sheet. If such sheet does not exist, it gets created. Note that if ExportVisualSettings is true, collecting the visual styles from the RadPropertyGrid will still execute on the UI thread.

Declaration

public void RunExportAsync(Stream exportStream, ISpreadExportRenderer exportRenderer, string sheetName)

Parameters

System.IO.Stream exportStream The stream where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

System.String sheetName Name of the sheet.

RunExportAsync(String, ISpreadExportRenderer)

Starts an export operation that runs in a background thread. Note that if ExportVisualSettings is true, collecting the visual styles from the RadPropertyGrid will still execute on the UI thread.

Declaration

public void RunExportAsync(string fileName, ISpreadExportRenderer exportRenderer)

Parameters

System.String fileName The file name where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

RunExportAsync(String, ISpreadExportRenderer, String)

Starts an async export operation, in the specified sheet. If such sheet does not exist, it gets created. Note that if ExportVisualSettings is true, collecting the visual styles from the RadPropertyGrid will still execute on the UI thread.

Declaration

public void RunExportAsync(string fileName, ISpreadExportRenderer exportRenderer, string sheetName)

Parameters

System.String fileName The file name where data will be exported.

ISpreadExportRenderer exportRenderer Instance of ISpreadExportRenderer class.

System.String sheetName Name of the sheet.

Events

AsyncExportCompleted

Occurs when an async export operation is completed.

Declaration

public event AsyncCompletedEventHandler AsyncExportCompleted

Event Type

System.ComponentModel.AsyncCompletedEventHandler

AsyncExportProgressChanged

Occurs when the progress of an async export operation changes.

Declaration

public event ProgressChangedEventHandler AsyncExportProgressChanged

Event Type

System.ComponentModel.ProgressChangedEventHandler

CellFormatting

Occurs for every cell that is being exported.

Declaration

public event PropertyGridSpreadExportCellFormattingEventHandler CellFormatting

Event Type

PropertyGridSpreadExportCellFormattingEventHandler

ExportCompleted

Occurs when the export process completes.

Declaration

public event EventHandler ExportCompleted

Event Type

System.EventHandler

Extension Methods

SvgExtentions.Traverse<T>(T, Func<T, IEnumerable<T>>)

SvgExtentions.TraverseDepthFirst<T>(T, Func<T, IEnumerable<T>>)