Represents a class which exposes all methods needed to export using RadSpreadStreamProcessing.
Definition
Namespace:Telerik.WinControls.Export
Assembly:TelerikExport.dll
Syntax:
public class SpreadStreamExportRenderer : ISpreadStreamExportRendererInheritance: objectSpreadStreamExportRenderer
Implements:
Constructors
public SpreadStreamExportRenderer()Properties
Gets or sets the index of the column.
public int ColumnIndex { get; set; }The index of the column.
Implements:
Methods
Create and add excel worksheet to the workbook.
public virtual void AddWorksheet(string sheetName)Excel workbook.
Implements:
Applies the cell format. Note that format needs to be of SpreadCellFormat type in order to be applied to current cell.
Applies the cell style.
public virtual void ApplyCellStyle(ISpreadStreamExportCellStyleInfo cellStyle, string formatString)The cell style.
formatStringstringThe format string.
Implements:
Calls the WorksheetCreated event.
Clears the value of current Cell.
public virtual void ClearCellValue()Implements:
Creates the border cell style.
public virtual void CreateBorderCellStyle(ISpreadStreamExportCellStyleInfo cellStyle)The cell style.
Implements:
Creates CellSelection.
public virtual void CreateCell()Implements:
Creates a SpreadStreamCellStyleInfo by given visual styles.
public virtual void CreateCellStyle(Color backColor, Color foreColor, FontFamily fontFamily, double fontSize, bool isBold, bool isItalic, bool underline, ContentAlignment textAlignment, bool textWrap, BorderBoxStyle borderBoxStyle, Color borderColor, Color borderTopColor, Color borderBottomColor, Color borderRightColor, Color borderLeftColor)BackColor of cell.
foreColorColorForeColor of cell.
fontFamilyFontFamilyFontFamily of cell.
fontSizedoubleFont size of cell.
isBoldboolIs text bold.
isItalicboolIs text italic.
underlineboolIs text underlined.
textAlignmentContentAlignmentText alignment.
textWrapboolIs text wrapped.
borderBoxStyleBorderBoxStyleBorder box style.
borderColorColorColor of border.
borderTopColorColorColor of top border.
borderBottomColorColorColor of bottom border.
borderRightColorColorColor of right border.
borderLeftColorColorColor of left border.
Implements:
Creates the cell style from light style.
public virtual ISpreadStreamExportCellStyleInfo CreateCellStyleFromLightStyle(ISpreadStreamExportCellStyleInfo cellStyle)The cell style.
Returns:Implements:
Creates SpreadStreamCellStyleInfo from theme normal style.
public virtual void CreateCellStyleFromTheme()Implements:
Creates the column.
public virtual void CreateColumn()Implements:
Creates a SpreadStreamLightCellStyleInfo by given visual styles.
public virtual void CreateLightCellStyle(Color backColor, Color foreColor, FontFamily fontFamily, double fontSize, bool isBold, bool isItalic, bool underline, ContentAlignment textAlignment, bool textWrap, BorderBoxStyle borderBoxStyle, Color borderColor, Color borderTopColor, Color borderBottomColor, Color borderRightColor, Color borderLeftColor)BackColor of cell.
foreColorColorForeColor of cell.
fontFamilyFontFamilyFontFamily of cell.
fontSizedoubleFont size of cell.
isBoldboolIs text bold.
isItalicboolIs text italic.
underlineboolIs text underlined.
textAlignmentContentAlignmentText alignment.
textWrapboolIs text wrapped.
borderBoxStyleBorderBoxStyleBorder box style.
borderColorColorColor of border.
borderTopColorColorColor of top border.
borderBottomColorColorColor of bottom border.
borderRightColorColorColor of right border.
borderLeftColorColorColor of left border.
Implements:
Creates the row.
public virtual void CreateRow()Implements:
Creates new workbook.
public virtual void CreateWorkbook(Stream stream, SpreadStreamExportFormat exportFormat, FileExportMode fileExportMode)The stream.
exportFormatSpreadStreamExportFormatThe export format.
fileExportModeFileExportModeThe file export mode.
Implements:
Creates new workbook.
public virtual void CreateWorkbook(Stream stream, SpreadStreamExportFormat exportFormat)The stream.
exportFormatSpreadStreamExportFormatThe export format.
Implements:
Finishes the cell.
public virtual void FinishCell()Implements:
Finishes the column.
protected virtual void FinishColumn()Exports workbook.
public virtual void FinishExport()Implements:
Finishes the row.
protected virtual void FinishRow()Finishes the workbook.
protected virtual void FinishWorkbook()Finishes the worksheet.
protected virtual void FinishWorksheet()Gets the borders from existing style.
public virtual ISpreadStreamExportCellStyleInfo GetBordersFromExistingStyle(ISpreadStreamExportCellStyleInfo cellStyle)The cell style.
Returns:Implements:
Gets current Cell.
Gets the cell style info.
public virtual ISpreadStreamExportCellStyleInfo GetCellStyleInfo()Implements:
Gets the column.
Gets file extension.
public virtual string GetFileExtension(SpreadStreamExportFormat exportFormat)Export format.
Returns:Implements:
Determines if a cell(by given row and column index) belongs to a merged cell.
Gets current worksheet.
Groups current row in current worksheet.
Raises the event.
protected virtual void OnWorkbookCreated(SpreadStreamWorkbookEventArgs e)The SpreadStreamWorkbookEventArgs instance containing the event data.
Raises the event.
protected virtual bool OnWorksheetCreated(SpreadStreamWorksheetEventArgs e)The SpreadStreamWorksheetEventArgs instance containing the event data.
Returns:Raises the event.
protected virtual void OnWorksheetExporting(SpreadStreamWorksheetEventArgs e)The SpreadStreamWorksheetEventArgs instance containing the event data.
Sets the value of current CellSelection.
Sets current worksheet column as hidden.
public virtual void SetHiddenColumn()Implements:
Sets current worksheet row as hidden.
public virtual void SetHiddenRow()Implements:
Skips the cells.
Skips the columns.
Events
Occurs when the workbook is created. This is suitable place to add and/or modify cell styles.
public event SpreadStreamWorkbookEventHandler WorkbookCreatedOccurs when a new worksheet is created. This is suitable place to set width of columns, add indent/header rows.
public event SpreadStreamWorksheetEventHandler WorksheetCreatedOccurs when a worksheet is about to be exported. This is suitable place to add footer rows.
public event SpreadStreamWorksheetEventHandler WorksheetExporting