Class FontSetting
FontSetting class
Represents a range of characters within the cell text.
Constructors
| Name | Description |
|---|
| FontSetting(int, int, WorksheetCollection) | |
Properties
| Name | Description |
|---|
| Font { get; } | Returns the font of this object. |
| Length { get; } | Gets the length of the characters. |
| StartIndex { get; } | Gets the start index of the characters. |
| TextOptions { get; } | Returns the text options. |
| virtual Type { get; } | Gets the type of text node. |
Methods
| Name | Description |
|---|
| SetWordArtStyle(PresetWordArtStyle) | Sets the preset WordArt style. |
Examples
[C#]
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Excel object
workbook.Worksheets.Add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];
//Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];
//Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!");
//getting charactor
FontSetting charactor = cell.Characters(6, 7);
//Setting the font of selected characters to bold
charactor.Font.IsBold = true;
//Setting the font color of selected characters to blue
charactor.Font.Color = Color.Blue;
//Saving the Excel file
workbook.Save("book1.xls");
[VB.NET]
'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Adding a new worksheet to the Excel object
workbook.Worksheets.Add()
'Obtaining the reference of the newly added worksheet by passing its sheet index
Dim worksheet As Worksheet = workbook.Worksheets(0)
'Accessing the "A1" cell from the worksheet
Dim cell As Aspose.Cells.Cell = worksheet.Cells("A1")
'Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!")
'getting charactor
Dim charactor As FontSetting = cell.Characters(6, 7)
'Setting the font of selected characters to bold
charactor.Font.IsBold = True
'Setting the font color of selected characters to blue
charactor.Font.Color = Color.Blue
'Saving the Excel file
workbook.Save("book1.xls")
See Also
