asposecells.api

Classes

Constants

Class Font

Encapsulates the font object used in a spreadsheet.

Example:

# Instantiating a Workbook object
workbook = Workbook()
# 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("Hello Aspose!")
style = cell.getStyle()
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(Color.getRed())
cell.setStyle(style)
# Saving the Excel file
workbook.save("Book1.xls")

Property Getters/Setters Summary
`method`	`getArgbColor()`
`method`	`setArgbColor(value)`
	Gets and sets the color with a 32-bit ARGB value.
`method`	`getCapsType()`
`method`	`setCapsType(value)`
	Gets and sets the text caps type. The value of the property is TextCapsType integer constant.
`method`	`getCharset()`
`method`	`setCharset(value)`
	Represent the character set.
`method`	`getColor()`
`method`	`setColor(value)`
	Gets or sets the `com.aspose.cells.Color` of the font.
`method`	`getDoubleSize()`
`method`	`setDoubleSize(value)`
	Gets and sets the double size of the font.
`method`	`isBold()`
`method`	`setBold(value)`
	Gets or sets a value indicating whether the font is bold.
`method`	`isItalic()`
`method`	`setItalic(value)`
	Gets or sets a value indicating whether the font is italic.
`method`	`isNormalizeHeights()`
`method`	`setNormalizeHeights(value)`
	Indicates whether the normalization of height that is to be applied to the text run.
`method`	`isStrikeout()`
`method`	`setStrikeout(value)`
	Gets or sets a value indicating whether the font is single strikeout.
`method`	`isSubscript()`
`method`	`setSubscript(value)`
	Gets or sets a value indicating whether the font is subscript.
`method`	`isSuperscript()`
`method`	`setSuperscript(value)`
	Gets or sets a value indicating whether the font is super script.
`method`	`getName()`
`method`	`setName(value)`
	Gets or sets the name of the Font.
`method`	`getSchemeType()`
`method`	`setSchemeType(value)`
	Gets and sets the scheme type of the font. The value of the property is FontSchemeType integer constant.
`method`	`getScriptOffset()`
`method`	`setScriptOffset(value)`
	Gets and sets the script offset,in unit of percentage
`method`	`getSize()`
`method`	`setSize(value)`
	Gets or sets the size of the font.
`method`	`getStrikeType()`
`method`	`setStrikeType(value)`
	Gets the strike type of the text. The value of the property is TextStrikeType integer constant.
`method`	`getThemeColor()`
`method`	`setThemeColor(value)`
	Gets and sets the theme color.
`method`	`getUnderline()`
`method`	`setUnderline(value)`
	Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.

Method Summary
`method`	`equals(font)`
`method`	Checks if two fonts are equals.
`method`	`toString()`
`method`	Returns a string represents the current Cell object.

- Property Getters/Setters Detail
  - getCharset/setCharset : int
```
int getCharset() / setCharset(value)
```
    Represent the character set.
  - isItalic/setItalic : boolean
```
boolean isItalic() / setItalic(value)
```
    Gets or sets a value indicating whether the font is italic.
  - isBold/setBold : boolean
```
boolean isBold() / setBold(value)
```
    Gets or sets a value indicating whether the font is bold.
  - getCapsType/setCapsType : int
```
int getCapsType() / setCapsType(value)
```
    Gets and sets the text caps type. The value of the property is TextCapsType integer constant.
  - getStrikeType/setStrikeType : int
```
int getStrikeType() / setStrikeType(value)
```
    Gets the strike type of the text. The value of the property is TextStrikeType integer constant.
  - isStrikeout/setStrikeout : boolean
```
boolean isStrikeout() / setStrikeout(value)
```
    Gets or sets a value indicating whether the font is single strikeout.
  - getScriptOffset/setScriptOffset : float
```
float getScriptOffset() / setScriptOffset(value)
```
    Gets and sets the script offset,in unit of percentage
  - isSuperscript/setSuperscript : boolean
```
boolean isSuperscript() / setSuperscript(value)
```
    Gets or sets a value indicating whether the font is super script.
  - isSubscript/setSubscript : boolean
```
boolean isSubscript() / setSubscript(value)
```
    Gets or sets a value indicating whether the font is subscript.
  - getUnderline/setUnderline : int
```
int getUnderline() / setUnderline(value)
```
    Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.
  - getName/setName : String
```
String getName() / setName(value)
```
    Gets or sets the name of the Font.
    Example:
    workbook = Workbook() # 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("Hello Aspose!") style = cell.getStyle() font = style.getFont() font.setName("Times New Roman") cell.setStyle(style)
  - getDoubleSize/setDoubleSize : float
```
float getDoubleSize() / setDoubleSize(value)
```
    Gets and sets the double size of the font.
  - getSize/setSize : int
```
int getSize() / setSize(value)
```
    Gets or sets the size of the font.
  - getThemeColor/setThemeColor : ThemeColor
```
ThemeColor getThemeColor() / setThemeColor(value)
```
    Gets and sets the theme color.
    If the font color is not a theme color, NULL will be returned.
  - getColor/setColor : Color
```
Color getColor() / setColor(value)
```
    Gets or sets the com.aspose.cells.Color of the font.
  - getArgbColor/setArgbColor : int
```
int getArgbColor() / setArgbColor(value)
```
    Gets and sets the color with a 32-bit ARGB value.
  - isNormalizeHeights/setNormalizeHeights : boolean
```
boolean isNormalizeHeights() / setNormalizeHeights(value)
```
    Indicates whether the normalization of height that is to be applied to the text run.
  - getSchemeType/setSchemeType : int
```
int getSchemeType() / setSchemeType(value)
```
    Gets and sets the scheme type of the font. The value of the property is FontSchemeType integer constant.
- Method Detail
  - equals
```
boolean equals(font)
```
    Checks if two fonts are equals.
    Parameters:
    font: Font - Compared font object.
    Returns:
    True if equal to the compared font object.
  - toString
```
String toString()
```
    Returns a string represents the current Cell object.
    Returns:

asposecells.api

Classes

Constants

Class Font

Property Getters/Setters Detail

getCharset/setCharset : int

isItalic/setItalic : boolean

isBold/setBold : boolean

getCapsType/setCapsType : int

getStrikeType/setStrikeType : int

isStrikeout/setStrikeout : boolean

getScriptOffset/setScriptOffset : float

isSuperscript/setSuperscript : boolean

isSubscript/setSubscript : boolean

getUnderline/setUnderline : int

getName/setName : String

getDoubleSize/setDoubleSize : float

getSize/setSize : int

getThemeColor/setThemeColor : ThemeColor

getColor/setColor : Color

getArgbColor/setArgbColor : int

isNormalizeHeights/setNormalizeHeights : boolean

getSchemeType/setSchemeType : int

Method Detail

equals

toString