asposecells.api

asposecells.api

Class ThemeColor

Represents a theme color.

Example:

# Instantiating a Workbook object
workbook = Workbook()
cells = workbook.getWorksheets().get(0).getCells()
cells.get("A1").putValue("Hello World")
style = cells.get("A1").getStyle()
# Set ThemeColorType.Text2 color type with 40% lighten as the font color.
style.getFont().setThemeColor(ThemeColor(ThemeColorType.TEXT_2, 0.4))
style.setPattern(BackgroundType.SOLID)
# Set ThemeColorType.Background2 color type with 75% darken as the foreground color
style.setForegroundThemeColor(ThemeColor(ThemeColorType.BACKGROUND_2, -0.75))
cells.get("A1").setStyle(style)
# Saving the Excel file
workbook.save("Book1.xlsx")

Constructor Summary
ThemeColor(type, tint)
 
Property Getters/Setters Summary
methodgetColorType()
method
setColorType(value)
           Gets and sets the theme type. The value of the property is ThemeColorType integer constant.
methodgetTint()
method
setTint(value)
           Gets and sets the tint value.
 

    • Constructor Detail

      • ThemeColor

        ThemeColor(type, tint)
        Parameters:
        type: int - A ThemeColorType value. The theme type.
        tint: float - The tint value.

    • Property Getters/Setters Detail

      • getColorType/setColorType : int 

        int getColorType() / setColorType(value)
        Gets and sets the theme type. The value of the property is ThemeColorType integer constant.

      • getTint/setTint : float 

        float getTint() / setTint(value)
        Gets and sets the tint value. The tint value is stored as a double from -1.0 .. 1.0, where -1.0 means 100% darken and 1.0 means 100% lighten. Also, 0.0 means no change.