Class CellBuilder

Inheritance

System.Object

Syncfusion.EJ2.ControlBuilder

CellBuilder

Namespace: Syncfusion.EJ2.Spreadsheet

Assembly: Syncfusion.EJ2.dll

Syntax

public class CellBuilder : ControlBuilder

Constructors

CellBuilder()

Declaration

public CellBuilder()

CellBuilder(List<Cell>)

Declaration

public CellBuilder(List<Cell> collection)

Parameters

Type	Name	Description
System.Collections.Generic.List<Cell>	collection

Methods

Add()

Declaration

public void Add()

Chart(Action<ChartBuilder>)

Declaration

public CellBuilder Chart(Action<ChartBuilder> chart)

Parameters

Type	Name	Description
System.Action<ChartBuilder>	chart

Returns

Type
CellBuilder

Chart(List<Chart>)

Specifies the chart of the cell.

Declaration

public CellBuilder Chart(List<Chart> chart)

Parameters

Type	Name	Description
System.Collections.Generic.List<Chart>	chart

Returns

Type
CellBuilder

ColSpan(Int32)

Specifies the column-wise cell merge count.

Declaration

public CellBuilder ColSpan(int colSpan)

Parameters

Type	Name	Description
System.Int32	colSpan

Returns

Type
CellBuilder

Format(String)

Specifies the number format code to display value in specified number format.

Declaration

public CellBuilder Format(string format)

Parameters

Type	Name	Description
System.String	format

Returns

Type
CellBuilder

Formula(String)

Defines the formula or expression of the cell.

Declaration

public CellBuilder Formula(string formula)

Parameters

Type	Name	Description
System.String	formula

Returns

Type
CellBuilder

Hyperlink(SpreadsheetHyperlink)

Specifies the hyperlink of the cell.

Declaration

public CellBuilder Hyperlink(SpreadsheetHyperlink hyperlink)

Parameters

Type	Name	Description
SpreadsheetHyperlink	hyperlink

Returns

Type
CellBuilder

Hyperlink(Action<SpreadsheetHyperlinkBuilder>)

Declaration

public CellBuilder Hyperlink(Action<SpreadsheetHyperlinkBuilder> hyperlink)

Parameters

Type	Name	Description
System.Action<SpreadsheetHyperlinkBuilder>	hyperlink

Returns

Type
CellBuilder

Hyperlink(Object)

Specifies the hyperlink of the cell.

Declaration

public CellBuilder Hyperlink(object hyperlink)

Parameters

Type	Name	Description
System.Object	hyperlink

Returns

Type
CellBuilder

Hyperlink(String)

Specifies the hyperlink of the cell.

Declaration

public CellBuilder Hyperlink(string hyperlink)

Parameters

Type	Name	Description
System.String	hyperlink

Returns

Type
CellBuilder

Image(Action<ImageBuilder>)

Declaration

public CellBuilder Image(Action<ImageBuilder> image)

Parameters

Type	Name	Description
System.Action<ImageBuilder>	image

Returns

Type
CellBuilder

Image(List<Image>)

Specifies the image of the cell.

Declaration

public CellBuilder Image(List<Image> image)

Parameters

Type	Name	Description
System.Collections.Generic.List<Image>	image

Returns

Type
CellBuilder

Index(Int32)

Specifies the index of the cell.

Declaration

public CellBuilder Index(int index)

Parameters

Type	Name	Description
System.Int32	index

Returns

Type
CellBuilder

IsLocked(Boolean)

Specifies the cell is locked or not, for allow edit range in spreadsheet protect option.

Declaration

public CellBuilder IsLocked(bool isLocked)

Parameters

Type	Name	Description
System.Boolean	isLocked

Returns

Type
CellBuilder

IsReadOnly(Boolean)

Represents whether a cell in the sheet is read-only or not. If set to true, it prevents editing the specified cell in the sheet.

Declaration

public CellBuilder IsReadOnly(bool isReadOnly)

Parameters

Type	Name	Description
System.Boolean	isReadOnly

Returns

Type
CellBuilder

Notes(String)

Specifies the note of the cell.

Declaration

public CellBuilder Notes(string notes)

Parameters

Type	Name	Description
System.String	notes

Returns

Type
CellBuilder

RowSpan(Int32)

Specifies the row-wise cell merge count.

Declaration

public CellBuilder RowSpan(int rowSpan)

Parameters

Type	Name	Description
System.Int32	rowSpan

Returns

Type
CellBuilder

Style(SpreadsheetCellStyle)

Specifies the cell style options.

Declaration

public CellBuilder Style(SpreadsheetCellStyle style)

Parameters

Type	Name	Description
SpreadsheetCellStyle	style

Returns

Type
CellBuilder

Style(Action<SpreadsheetCellStyleBuilder>)

Declaration

public CellBuilder Style(Action<SpreadsheetCellStyleBuilder> style)

Parameters

Type	Name	Description
System.Action<SpreadsheetCellStyleBuilder>	style

Returns

Type
CellBuilder

Validation(SpreadsheetValidation)

Specifies the validation of the cell.

Declaration

public CellBuilder Validation(SpreadsheetValidation validation)

Parameters

Type	Name	Description
SpreadsheetValidation	validation

Returns

Type
CellBuilder

Validation(Action<SpreadsheetValidationBuilder>)

Declaration

public CellBuilder Validation(Action<SpreadsheetValidationBuilder> validation)

Parameters

Type	Name	Description
System.Action<SpreadsheetValidationBuilder>	validation

Returns

Type
CellBuilder

Value(String)

Defines the value of the cell which can be text or number.

Declaration

public CellBuilder Value(string value)

Parameters

Type	Name	Description
System.String	value

Returns

Type
CellBuilder

Wrap(Boolean)

Wraps the cell text to the next line, if the text width exceeds the column width.

Declaration

public CellBuilder Wrap(bool wrap)

Parameters

Type	Name	Description
System.Boolean	wrap

Returns

Type
CellBuilder