Interface IWorksheetExporter

Streams rows, columns, merged ranges, and view/page settings for a single worksheet.

Inherited Members

System.IDisposable.Dispose()

Namespace: Telerik.Documents.SpreadsheetStreaming

Assembly: Telerik.Documents.SpreadsheetStreaming.dll

Syntax

public interface IWorksheetExporter : IDisposable

Methods

CreateColumnExporter()

Create a column exporter for defining column widths and grouping before writing rows.

Declaration

IColumnExporter CreateColumnExporter()

Returns

IColumnExporter The column exporter.

CreatePageSetupExporter()

Create a page setup exporter to configure print layout settings for the sheet.

Declaration

IPageSetupExporter CreatePageSetupExporter()

Returns

IPageSetupExporter The page setup exporter.

CreateRowExporter()

Create a row exporter positioned at the next row for writing cells.

Declaration

IRowExporter CreateRowExporter()

Returns

IRowExporter The row exporter.

CreateWorksheetViewExporter()

Create a view exporter to configure viewport state (freeze panes, zoom, selection, visibility).

Declaration

IWorksheetViewExporter CreateWorksheetViewExporter()

Returns

IWorksheetViewExporter The worksheet view exporter.

MergeCells(Int32, Int32, Int32, Int32)

Merge a rectangular region of cells defined by its start and end row/column indices.

Declaration

void MergeCells(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex)

Parameters

System.Int32 fromRowIndex The start row index of the area.

System.Int32 fromColumnIndex The start column index of the area.

System.Int32 toRowIndex The end row index of the area.

System.Int32 toColumnIndex The end column index of the area.

SkipColumns(Int32)

Advance the internal column position by a given number without writing cells.

Declaration

void SkipColumns(int count)

Parameters

System.Int32 count The count of the columns to skip.

SkipRows(Int32)

Advance the internal row index by the specified number without emitting row elements.

Declaration

void SkipRows(int count)

Parameters

System.Int32 count The count of the rows to skip.