aspose.cells

Class FontSetting

Represents a range of characters within the cell text.

Example:

//Instantiating a Workbook object
$workbook = new cells\Workbook();
//Adding a new worksheet to the Excel object
$workbook->getWorksheets()->add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
$worksheet = $workbook->getWorksheets()->get(0);
//Accessing the "A1" cell from the worksheet
$cell = $worksheet->getCells()->get("A1");
//Adding some value to the "A1" cell
$cell->putValue("Visit Aspose!");
//getting charactor
$charactor = $cell->characters(6, 7);
//Setting the font of selected characters to bold
$charactor->getFont()->setBold(true);
//Setting the font color of selected characters to blue
$charactor->getFont()->setColor(cells\Color::getBlue());

Constructor Summary
FontSetting(startIndex, length, sheets)
 
Property Getters/Setters Summary
functiongetFont()
Returns the font of this object.
functiongetLength()
Gets the length of the characters.
functiongetStartIndex()
Gets the start index of the characters.
functiongetTextOptions()
Returns the text options.
functiongetType()
Gets the type of text node. The value of the property is TextNodeType integer constant.
 
Method Summary
functionsetWordArtStyle(style)
Sets the preset WordArt style.
 

    • Constructor Detail

      • FontSetting

        function FontSetting(startIndex, length, sheets)
        Parameters:
        startIndex: Number -
        length: Number -
        sheets: WorksheetCollection -
    • Property Getters/Setters Detail

      • getType : Number 

        function getType()
        
        Gets the type of text node. The value of the property is TextNodeType integer constant.
      • getStartIndex : Number 

        function getStartIndex()
        
        Gets the start index of the characters.
      • getLength : Number 

        function getLength()
        
        Gets the length of the characters.
      • getFont : Font 

        function getFont()
        
        Returns the font of this object.
      • getTextOptions : TextOptions 

        function getTextOptions()
        
        Returns the text options.
    • Method Detail

      • setWordArtStyle

        function setWordArtStyle(style)
        Sets the preset WordArt style. Only for the text of shape/chart.
        Parameters:
        style: Number - A PresetWordArtStyle value. The preset WordArt style.