Class GraphicCellHelper

Helper class for GraphicCells related stuffs.

Inheritance

System.Object

GraphicCellHelper

Namespace: Syncfusion.UI.Xaml.Spreadsheet.GraphicCells

Assembly: Syncfusion.SfSpreadsheet.WPF.dll

Syntax

public static class GraphicCellHelper : Object

Methods

Add3DGraphicChartCellRenderer(SfSpreadsheet, IGraphicCellRenderer)

Add IGraphicCellRenderer for 3D-charts, if 3D-charts need to be loaded into Spreadsheet

Declaration

public static void Add3DGraphicChartCellRenderer(this SfSpreadsheet spreadsheet, IGraphicCellRenderer renderer)

Parameters

Type	Name	Description
SfSpreadsheet	spreadsheet	SfSpreadsheet
IGraphicCellRenderer	renderer	CellRenderer for 3D-Chart

AddChart(SfSpreadsheet, IWorksheet)

Add Chart to worksheet

Declaration

public static IChart AddChart(this SfSpreadsheet sfSpreadsheet, IWorksheet sheet)

Parameters

Type	Name	Description
SfSpreadsheet	sfSpreadsheet	An instance of SfSpreadsheet
IWorksheet	sheet	An instance of IWorksheet

Returns

Type	Description
IChart	An instance of IChart

AddGraphicChartCellRenderer(SfSpreadsheet, IGraphicCellRenderer)

Add IGraphicCellRenderer for charts, if charts need to be loaded into Spreadsheet

Declaration

public static void AddGraphicChartCellRenderer(this SfSpreadsheet spreadsheet, IGraphicCellRenderer renderer)

Parameters

Type	Name	Description
SfSpreadsheet	spreadsheet	SfSpreadsheet
IGraphicCellRenderer	renderer	CellRenderer for Chart

AddImage(SfSpreadsheet, IWorksheet, RowColumnIndex, Stream)

Add an image to worksheet

Declaration

public static ShapeImpl AddImage(this SfSpreadsheet sfSpreadsheet, IWorksheet sheet, RowColumnIndex rowColIndex, Stream stream)

Parameters

Type	Name	Description
SfSpreadsheet	sfSpreadsheet	An instance of SfSpreadsheet
IWorksheet	sheet	An instance of IWorksheet
RowColumnIndex	rowColIndex	RowColumnIndex where an image is to be placed
System.IO.Stream	stream	file stream

Returns

Type	Description
ShapeImpl	An instance of

AddSparklineCellRenderer(SfSpreadsheet, ISpreadsheetCellRenderer)

Add ISpreadsheetCellRenderer for sparklines, if sparklines need to be loaded into Spreadsheet

Declaration

public static void AddSparklineCellRenderer(this SfSpreadsheet spreadsheet, ISpreadsheetCellRenderer renderer)

Parameters

Type	Name	Description
SfSpreadsheet	spreadsheet	SfSpreadsheet
ISpreadsheetCellRenderer	renderer	CellRenderer for Sparkline

AddTextBox(SfSpreadsheet, IWorksheet, RowColumnIndex, Size, String)

Add TextBox to worksheet

Declaration

public static TextBoxShapeImpl AddTextBox(this SfSpreadsheet sfSpreadsheet, IWorksheet worksheet, RowColumnIndex rowColumnIndex, Size size, string richText)

Parameters

Type	Name	Description
SfSpreadsheet	sfSpreadsheet	An instance of SfSpreadsheet
IWorksheet	worksheet	An instance of IWorksheet
RowColumnIndex	rowColumnIndex	rowColumnIndex where TextBox is to be placed
System.Windows.Size	size	size of the RichTextBox
System.String	richText	rich text

Returns

Type	Description
TextBoxShapeImpl	An instance of TextBoxShapeImpl