Cell.Characters

Cell.Characters method

Returns a Characters object that represents a range of characters within the cell text.

public FontSetting Characters(int startIndex, int length)
ParameterTypeDescription
startIndexInt32The index of the start of the character.
lengthInt32The number of characters.

Return Value

Characters object.

Remarks

This method only works on cell with string value.

Examples

[C#]
Workbook excel = new Workbook();
Cells cells = excel.Worksheets[0].Cells;
cells["A1"].PutValue("Helloworld");
cells["A1"].Characters(5, 5).Font.IsBold = true;
cells["A1"].Characters(5, 5).Font.Color = Color.Blue;

[Visual Basic]
Dim excel as Workbook = new Workbook()
Dim cells as Cells = exce.Worksheets(0).Cells
cells("A1").PutValue("Helloworld")
cells("A1").Characters(5, 5).Font.IsBold = True
cells("A1").Characters(5, 5).Font.Color = Color.Blue

See Also