Class GraphicCellHelper
Helper class for GraphicCells related stuffs.
Inheritance
Inherited Members
Namespace: Syncfusion.Windows.Forms.Spreadsheet.GraphicCells
Assembly: Syncfusion.Spreadsheet.Windows.dll
Syntax
public static class GraphicCellHelper
Methods
Add3DGraphicChartCellRenderer(Spreadsheet, IGraphicCellRenderer)
Add IGraphicCellRenderer for 3D-charts, if 3D-charts need to be loaded into Spreadsheet
Declaration
public static void Add3DGraphicChartCellRenderer(this Spreadsheet spreadsheet, IGraphicCellRenderer renderer)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | spreadsheet | SfSpreadsheet |
IGraphicCellRenderer | renderer | CellRenderer for 3D-Chart |
AddChart(Spreadsheet, IWorksheet)
Add Chart to worksheet
Declaration
public static IChart AddChart(this Spreadsheet sfSpreadsheet, IWorksheet sheet)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | sfSpreadsheet | An instance of Spreadsheet |
IWorksheet | sheet | An instance of IWorksheet |
Returns
Type | Description |
---|---|
IChart | An instance of IChart |
AddGraphicChartCellRenderer(Spreadsheet, IGraphicCellRenderer)
Add IGraphicCellRenderer for charts, if charts need to be loaded into Spreadsheet
Declaration
public static void AddGraphicChartCellRenderer(this Spreadsheet spreadsheet, IGraphicCellRenderer renderer)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | spreadsheet | SfSpreadsheet |
IGraphicCellRenderer | renderer | CellRenderer for Chart |
AddImage(Spreadsheet, IWorksheet, RowColumnIndex, Stream)
Add an image to worksheet
Declaration
public static ShapeImpl AddImage(this Spreadsheet sfSpreadsheet, IWorksheet sheet, RowColumnIndex rowColIndex, Stream stream)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | sfSpreadsheet | An instance of Spreadsheet |
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(Spreadsheet, ISpreadsheetCellRenderer)
Add ISpreadsheetCellRenderer for sparklines, if sparklines need to be loaded into Spreadsheet
Declaration
public static void AddSparklineCellRenderer(this Spreadsheet spreadsheet, ISpreadsheetCellRenderer renderer)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | spreadsheet | SfSpreadsheet |
ISpreadsheetCellRenderer | renderer | CellRenderer for Sparkline |
AddTextBox(Spreadsheet, IWorksheet, RowColumnIndex, Size, String)
Add TextBox to worksheet
Declaration
public static TextBoxShapeImpl AddTextBox(this Spreadsheet sfSpreadsheet, IWorksheet worksheet, RowColumnIndex rowColumnIndex, Size size, string richText)
Parameters
Type | Name | Description |
---|---|---|
Spreadsheet | sfSpreadsheet | An instance of Spreadsheet |
IWorksheet | worksheet | An instance of IWorksheet |
RowColumnIndex | rowColumnIndex | rowColumnIndex where TextBox is to be placed |
System.Drawing.Size | size | size of the RichTextBox |
System.String | richText | rich text |
Returns
Type | Description |
---|---|
TextBoxShapeImpl | An instance of TextBoxShapeImpl |