Documentation

Class TreeViewSpreadExport

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

Inheritance
System.Object
TreeViewSpreadExport
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 TreeViewSpreadExport

Constructors

TreeViewSpreadExport(RadTreeView)

Initializes a new instance of the TreeViewSpreadExport class.

Declaration
public TreeViewSpreadExport(RadTreeView radTreeView)
Parameters
RadTreeView radTreeView

The RadTreeView to export.

TreeViewSpreadExport(RadTreeView, SpreadExportFormat)

Initializes a new instance of the TreeViewSpreadExport class.

Declaration
public TreeViewSpreadExport(RadTreeView radTreeView, SpreadExportFormat exportFormat)
Parameters
RadTreeView radTreeView

The RadTreeView to export.
SpreadExportFormat exportFormat

The export format.

Properties

CollapsedNodeOption

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

Declaration
public HiddenOption CollapsedNodeOption { get; set; }
Property Value
HiddenOption

ExportCheckBoxes

Gets or sets a value indicating whether to export the check box values, when they are shown in tree nodes.

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

ExportChildNodesGrouped

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

Declaration
public bool ExportChildNodesGrouped { 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.

ExportImages

Gets or sets a value indicating whether to export images.

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

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

NodeIndent

Gets or sets the indent of child nodes.

Declaration
public int NodeIndent { 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(TreeViewSpreadExportCell, Int32, Int32)

Declaration
protected virtual void CreateCell(TreeViewSpreadExportCell cell, int currentRowIndex, int currentColumnIndex)
Parameters
TreeViewSpreadExportCell cell

System.Int32 currentRowIndex

System.Int32 currentColumnIndex

CreateImageOverCell(TreeViewSpreadExportImageCell, Int32, Int32)

Declaration
protected virtual void CreateImageOverCell(TreeViewSpreadExportImageCell cell, int currentRowIndex, int currentColumnIndex)
Parameters
TreeViewSpreadExportImageCell cell

System.Int32 currentRowIndex

System.Int32 currentColumnIndex

GetStylesFromVisualCell(TreeViewSpreadExportCell, LightVisualElement)

Declaration
protected virtual void GetStylesFromVisualCell(TreeViewSpreadExportCell cell, LightVisualElement visualCell)
Parameters
TreeViewSpreadExportCell 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(TreeViewSpreadExportCellFormattingEventArgs)

Raises the CellFormatting event.

Declaration
protected virtual void OnCellFormatting(TreeViewSpreadExportCellFormattingEventArgs e)
Parameters
TreeViewSpreadExportCellFormattingEventArgs e

The TreeViewSpreadExportCellFormattingEventArgs 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 RadTreeView 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 RadTreeView 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 RadTreeView 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 RadTreeView 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 TreeViewSpreadExportCellFormattingEventHandler CellFormatting
Event Type
TreeViewSpreadExportCellFormattingEventHandler

ExportCompleted

Occurs when the export process completes.

Declaration
public event EventHandler ExportCompleted
Event Type
System.EventHandler

Extension Methods