Class GridViewSpreadStreamExport

Represents a grid export that utilizes the RadSpreadStreamProcessing library.

Inheritance
System.Object
GridViewSpreadStreamExport
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.GridView.dll

Syntax

public class GridViewSpreadStreamExport

Constructors

GridViewSpreadStreamExport(RadGridView)

Initializes a new instance of the GridViewSpreadExport class.

Declaration
public GridViewSpreadStreamExport(RadGridView radGridView)
Parameters
RadGridView radGridView

The grid to export.

GridViewSpreadStreamExport(RadGridView, SpreadStreamExportFormat)

Initializes a new instance of the GridViewSpreadExport class.

Declaration
public GridViewSpreadStreamExport(RadGridView radGridView, SpreadStreamExportFormat spreadExportFormat)
Parameters
RadGridView radGridView

The grid to export.
SpreadStreamExportFormat spreadExportFormat

The spread export format.

Properties

ChildViewExportMode

Gets or sets the child view export mode.

Declaration
public ChildViewExportMode ChildViewExportMode { get; set; }
Property Value
ChildViewExportMode

The child view export mode.

ExportChildRowsGrouped

Gets or sets a value indicating whether to export hierarchy and group child rows grouped.

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

ExportFormat

Gets or sets the format of the exported file - XLSX or CSV.

Declaration
public SpreadStreamExportFormat ExportFormat { get; set; }
Property Value
SpreadStreamExportFormat

The file extension.

ExportGroupedColumns

Gets or sets a value indicating whether to export grouped columns.

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

ExportHierarchy

Gets or set if child rows should be exported.

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

ExportViewDefinition

Gets or sets a value indicating whether to export view definition. Note that if using 

RunExportAsync
method to export, the view definition will not be exported.

Declaration
public bool ExportViewDefinition { 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 whether a file will be exported as a new file, or if a file with the same name already exists at the specified path, a new sheet will be added to it.

Declaration
public FileExportMode FileExportMode { get; set; }
Property Value
FileExportMode

ExportAsNewSheetInExistingFile - will add a new sheet to the specified file, if it exists ExportInNewFile - will create/override the specified file

FreezeHeaderRow

Gets or sets a value indicating whether to freeze the header row in the exported file.

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

FreezePinnedColumns

Gets or sets a value indicating whether to freeze pinned columns.

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

FreezePinnedRows

Gets or sets a value indicating whether to freeze pinned rows.

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

HiddenColumnOption

Gets or sets a value indicating how hidden columns are exported.

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

The hidden column option.

HiddenRowOption

Gets or sets a value indicating how hidden rows are exported.

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

The hidden row option.

PagingExportOption

Gets or sets a value indicating how the export behaves when paging is enabled.

Declaration
public PagingExportOption PagingExportOption { get; set; }
Property Value
PagingExportOption

The paging export option.

RadGridViewToExport

Gets or sets the RadGridView to export.

Declaration
public RadGridView RadGridViewToExport { get; set; }
Property Value
RadGridView

The RadGridView to export.

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.

SummariesExportOption

Gets or sets a value indicating how summary rows are exported.

Declaration
public SummariesOption SummariesExportOption { get; set; }
Property Value
SummariesOption

The summaries export option.

Methods

CancelExportAsync()

Cancels an asynchronous export operation.

Declaration
public void CancelExportAsync()

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(SpreadStreamCellFormattingEventArgs)

Raises the CellFormatting event.

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

The SpreadStreamCellFormattingEventArgs instance containing the event data.

OnChildViewExporting(ChildViewExportingEventArgs)

Raises the ChildViewExporting event.

Declaration
protected virtual void OnChildViewExporting(ChildViewExportingEventArgs e)
Parameters
ChildViewExportingEventArgs e

The ChildViewExportingEventArgs 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.

OnRowCreated(SpreadStreamRowEventArgs)

Raises the RowCreated event.

Declaration
protected virtual void OnRowCreated(SpreadStreamRowEventArgs e)
Parameters
SpreadStreamRowEventArgs e

The SpreadStreamRowEventArgs instance containing the event data.

OnRowExporting(SpreadStreamRowEventArgs)

Raises the RowExporting event.

Declaration
protected virtual void OnRowExporting(SpreadStreamRowEventArgs e)
Parameters
SpreadStreamRowEventArgs e

The SpreadStreamRowEventArgs instance containing the event data.

RunExport(Stream, ISpreadStreamExportRenderer)

Starts an export operation.

Declaration
public void RunExport(Stream exportStream, ISpreadStreamExportRenderer exportRenderer)
Parameters
System.IO.Stream exportStream

The stream where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.

RunExport(Stream, ISpreadStreamExportRenderer, String)

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

Declaration
public void RunExport(Stream exportStream, ISpreadStreamExportRenderer exportRenderer, string sheetName)
Parameters
System.IO.Stream exportStream

The stream where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.
System.String sheetName

Name of the sheet.

RunExport(String, ISpreadStreamExportRenderer)

Starts an export operation.

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

The file name where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.

RunExport(String, ISpreadStreamExportRenderer, String)

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

Declaration
public void RunExport(string fileName, ISpreadStreamExportRenderer exportRenderer, string sheetName)
Parameters
System.String fileName

The file name where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.
System.String sheetName

Name of the sheet.

RunExportAsync(Stream, ISpreadStreamExportRenderer)

Starts an export operation that runs in a background thread.

Declaration
public void RunExportAsync(Stream exportStream, ISpreadStreamExportRenderer exportRenderer)
Parameters
System.IO.Stream exportStream

The stream where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.

RunExportAsync(Stream, ISpreadStreamExportRenderer, String)

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

Declaration
public void RunExportAsync(Stream exportStream, ISpreadStreamExportRenderer exportRenderer, string sheetName)
Parameters
System.IO.Stream exportStream

The stream where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.
System.String sheetName

Name of the sheet.

RunExportAsync(String, ISpreadStreamExportRenderer)

Starts an export operation that runs in a background thread.

Declaration
public void RunExportAsync(string fileName, ISpreadStreamExportRenderer exportRenderer)
Parameters
System.String fileName

The file name where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer class.

RunExportAsync(String, ISpreadStreamExportRenderer, String)

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

Declaration
public void RunExportAsync(string fileName, ISpreadStreamExportRenderer exportRenderer, string sheetName)
Parameters
System.String fileName

The file name where data will be exported.
ISpreadStreamExportRenderer exportRenderer

Instance of ISpreadStreamExportRenderer 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 SpreadStreamCellFormattingEventHandler CellFormatting
Event Type
SpreadStreamCellFormattingEventHandler

ChildViewExporting

Occurs when a child view will be exported.

Declaration
public event ChildViewExportingEventHandler ChildViewExporting
Event Type
ChildViewExportingEventHandler

ExportCompleted

Occurs when the export process completes.

Declaration
public event EventHandler ExportCompleted
Event Type
System.EventHandler

RowCreated

Occurs when a new row is created in current worksheet. This is suitable place to set any row properties(like height) and/or add any indent cells.

Declaration
public event SpreadStreamRowEventHandler RowCreated
Event Type
SpreadStreamRowEventHandler

RowExporting

Occurs when a spread row is about to be exported. This is suitable place to add any additional cells at the end of the row.

Declaration
public event SpreadStreamRowEventHandler RowExporting
Event Type
SpreadStreamRowEventHandler

Extension Methods