com.aspose.cells

  • java.lang.Object
    • com.aspose.cells.Font
public class Font 
extends java.lang.Object

Encapsulates the font object used in a spreadsheet.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);

//Accessing the "A1" cell from the worksheet
Cell cell = worksheet.getCells().get("A1");

//Adding some value to the "A1" cell
cell.putValue("Hello Aspose!");

Style style = cell.getStyle();
Font font = style.getFont();

//Setting the font name to "Times New Roman"
font.setName("Times New Roman");

//Setting font size to 14
font.setSize(14);

//setting font color as Red
font.setColor(com.aspose.cells.Color.getRed());

cell.setStyle(style);

//Saving the Excel file
workbook.save("d:\\dest.xls");

Property Getters/Setters Summary
intgetArgbColor()
void
setArgbColor(intvalue)
           Gets and sets the color with a 32-bit ARGB value.
intgetCapsType()
void
setCapsType(intvalue)
           Gets and sets the text caps type. The value of the property is TextCapsType integer constant.
intgetCharset()
void
setCharset(intvalue)
           Represent the character set.
ColorgetColor()
void
setColor(Color value)
           Gets or sets the com.aspose.cells.Color of the font.
doublegetDoubleSize()
void
setDoubleSize(doublevalue)
           Gets and sets the double size of the font.
booleanisBold()
void
setBold(booleanvalue)
           Gets or sets a value indicating whether the font is bold.
booleanisItalic()
void
setItalic(booleanvalue)
           Gets or sets a value indicating whether the font is italic.
booleanisNormalizeHeights()
void
setNormalizeHeights(booleanvalue)
           Indicates whether the normalization of height that is to be applied to the text run.
booleanisStrikeout()
void
setStrikeout(booleanvalue)
           Gets or sets a value indicating whether the font is single strikeout.
booleanisSubscript()
void
setSubscript(booleanvalue)
           Gets or sets a value indicating whether the font is subscript.
booleanisSuperscript()
void
setSuperscript(booleanvalue)
           Gets or sets a value indicating whether the font is super script.
java.lang.StringgetName()
void
setName(java.lang.Stringvalue)
           Gets or sets the name of the Font.
intgetSchemeType()
void
setSchemeType(intvalue)
           Gets and set sthe scheme type of the font. The value of the property is FontSchemeType integer constant.
doublegetScriptOffset()
void
setScriptOffset(doublevalue)
           Gets and sets the sript offset,in unit of percentage
intgetSize()
void
setSize(intvalue)
           Gets or sets the size of the font.
intgetStrikeType()
void
setStrikeType(intvalue)
           Gets the strike type of the text. The value of the property is TextStrikeType integer constant.
ThemeColorgetThemeColor()
void
           Gets and sets the theme color.
intgetUnderline()
void
setUnderline(intvalue)
           Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.
 
Method Summary
booleanequals(Font font)
Checks if two fonts are equals.
java.lang.StringtoString()
Returns a string represents the current Cell object.
 

    • Property Getters/Setters Detail

      • getCharset/setCharset

        public int getCharset() / public void setCharset(int value)
        
        Represent the character set.
      • isItalic/setItalic

        public boolean isItalic() / public void setItalic(boolean value)
        
        Gets or sets a value indicating whether the font is italic.
      • isBold/setBold

        public boolean isBold() / public void setBold(boolean value)
        
        Gets or sets a value indicating whether the font is bold.
      • getCapsType/setCapsType

        public int getCapsType() / public void setCapsType(int value)
        
        Gets and sets the text caps type. The value of the property is TextCapsType integer constant.
      • getStrikeType/setStrikeType

        public int getStrikeType() / public void setStrikeType(int value)
        
        Gets the strike type of the text. The value of the property is TextStrikeType integer constant.
      • isStrikeout/setStrikeout

        public boolean isStrikeout() / public void setStrikeout(boolean value)
        
        Gets or sets a value indicating whether the font is single strikeout.
      • getScriptOffset/setScriptOffset

        public double getScriptOffset() / public void setScriptOffset(double value)
        
        Gets and sets the sript offset,in unit of percentage
      • isSuperscript/setSuperscript

        public boolean isSuperscript() / public void setSuperscript(boolean value)
        
        Gets or sets a value indicating whether the font is super script.
      • isSubscript/setSubscript

        public boolean isSubscript() / public void setSubscript(boolean value)
        
        Gets or sets a value indicating whether the font is subscript.
      • getUnderline/setUnderline

        public int getUnderline() / public void setUnderline(int value)
        
        Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.
      • getName/setName

        public java.lang.String getName() / public void setName(java.lang.String value)
        
        Gets or sets the name of the Font.

        Example:

        Font font = style.getFont();
        font.setName("Times New Roman");
      • getDoubleSize/setDoubleSize

        public double getDoubleSize() / public void setDoubleSize(double value)
        
        Gets and sets the double size of the font.
      • getSize/setSize

        public int getSize() / public void setSize(int value)
        
        Gets or sets the size of the font.
      • getThemeColor/setThemeColor

        public ThemeColor getThemeColor() / public void setThemeColor(ThemeColor value)
        
        Gets and sets the theme color. If the font color is not a theme color, NULL will be returned.
      • getColor/setColor

        public Color getColor() / public void setColor(Color value)
        
        Gets or sets the com.aspose.cells.Color of the font.
      • getArgbColor/setArgbColor

        public int getArgbColor() / public void setArgbColor(int value)
        
        Gets and sets the color with a 32-bit ARGB value.
      • isNormalizeHeights/setNormalizeHeights

        public boolean isNormalizeHeights() / public void setNormalizeHeights(boolean value)
        
        Indicates whether the normalization of height that is to be applied to the text run.
      • getSchemeType/setSchemeType

        public int getSchemeType() / public void setSchemeType(int value)
        
        Gets and set sthe scheme type of the font. The value of the property is FontSchemeType integer constant.
    • Method Detail

      • equals

        public boolean equals(Font font)
        Checks if two fonts are equals.
        Parameters:
        font - Compared font object.
        Returns:
        True if equal to the compared font object.
      • toString

        public java.lang.String toString()
        Returns a string represents the current Cell object.
        Returns: