Class CellStyleXlsx


  • public class CellStyleXlsx
    extends CellStyle
    Represents the style of Excel cells.
    • Constructor Detail

      • CellStyleXlsx

        public CellStyleXlsx()
        Represents the style of an Excell cell element. The options can be set with the setter functions.
    • Method Detail

      • getCellLocked

        public java.lang.Boolean getCellLocked()
        Returns:
        Whether the cell is locked.
      • setCellLocked

        public void setCellLocked​(java.lang.Boolean cellLocked)
        Parameters:
        cellLocked - Whether the cell is locked.
      • getCellHidden

        public java.lang.Boolean getCellHidden()
        Returns:
        Whether the cell is hidden.
      • setCellHidden

        public void setCellHidden​(java.lang.Boolean cellHidden)
        Parameters:
        cellHidden - Whether the cell is hidden.
      • getCellBackground

        public java.lang.String getCellBackground()
        Returns:
        Background color of the cell in hex format.
      • setCellBackground

        public void setCellBackground​(java.lang.String cellBackground)
        Parameters:
        cellBackground - Background color of the cell in hex format.
      • getFont

        public java.lang.String getFont()
        Returns:
        Font of the text in the cell.
      • setFont

        public void setFont​(java.lang.String font)
        Parameters:
        font - Font of the text in the cell.
      • getFontSize

        public java.lang.Integer getFontSize()
        Returns:
        Size of the font.
      • setFontSize

        public void setFontSize​(java.lang.Integer fontSize)
        Parameters:
        fontSize - Size of the font.
      • getFontColor

        public java.lang.String getFontColor()
        Returns:
        Color of the font.
      • setFontColor

        public void setFontColor​(java.lang.String fontColor)
        Parameters:
        fontColor - Color of the font.
      • getFontItalic

        public java.lang.Boolean getFontItalic()
        Returns:
        Whether the text is in italic.
      • setFontItalic

        public void setFontItalic​(java.lang.Boolean fontItalic)
        Parameters:
        fontItalic - Whether the text is in italic.
      • getFontBold

        public java.lang.Boolean getFontBold()
        Returns:
        Whether the text is in bold.
      • setFontBold

        public void setFontBold​(java.lang.Boolean fontBold)
        Parameters:
        fontBold - Whether the text is in bold.
      • getFontStrike

        public java.lang.Boolean getFontStrike()
        Returns:
        Whether the text is striked.
      • setFontStrike

        public void setFontStrike​(java.lang.Boolean fontStrike)
        Parameters:
        fontStrike - Whether the text is striked.
      • getFontUnderline

        public java.lang.Boolean getFontUnderline()
        Returns:
        Whether the text is underlined.
      • setFontUnderline

        public void setFontUnderline​(java.lang.Boolean fontUnderline)
        Parameters:
        fontUnderline - Whether the text is underlined.
      • getFontSuperscript

        public java.lang.Boolean getFontSuperscript()
        Returns:
        Whether the text is a superscript.
      • setFontSuperscript

        public void setFontSuperscript​(java.lang.Boolean fontSuperscript)
        Parameters:
        fontSuperscript - Whether the text is a superscript.
      • getFontSubscript

        public java.lang.Boolean getFontSubscript()
        Returns:
        Whether the text is a subscript.
      • setFontSubscript

        public void setFontSubscript​(java.lang.Boolean fontSubscript)
        Parameters:
        fontSubscript - Whether the text is a subscript.
      • getBorderTop

        public java.lang.String getBorderTop()
        Returns:
        Top border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • setBorderTop

        public void setBorderTop​(java.lang.String borderTop)
        Parameters:
        borderTop - Top border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • getBorderTopColor

        public java.lang.String getBorderTopColor()
        Returns:
        Top border color.
      • setBorderTopColor

        public void setBorderTopColor​(java.lang.String borderTopColor)
        Parameters:
        borderTopColor - Top border color.
      • getBorderBottom

        public java.lang.String getBorderBottom()
        Returns:
        Bottom border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • setBorderBottom

        public void setBorderBottom​(java.lang.String borderBottom)
        Parameters:
        borderBottom - Bottom border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • getBorderBottomColor

        public java.lang.String getBorderBottomColor()
        Returns:
        Bottom border color.
      • setBorderBottomColor

        public void setBorderBottomColor​(java.lang.String borderBottomColor)
        Parameters:
        borderBottomColor - Bottom border color.
      • getBorderLeft

        public java.lang.String getBorderLeft()
        Returns:
        Left border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • setBorderLeft

        public void setBorderLeft​(java.lang.String borderLeft)
        Parameters:
        borderLeft - Left border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • getBorderLeftColor

        public java.lang.String getBorderLeftColor()
        Returns:
        Left border color.
      • setBorderLeftColor

        public void setBorderLeftColor​(java.lang.String borderLeftColor)
        Parameters:
        borderLeftColor - Left border color.
      • getBorderRight

        public java.lang.String getBorderRight()
        Returns:
        Right border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • setBorderRight

        public void setBorderRight​(java.lang.String borderRight)
        Parameters:
        borderRight - Right border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • getBorderRightColor

        public java.lang.String getBorderRightColor()
        Returns:
        Right border color.
      • setBorderRightColor

        public void setBorderRightColor​(java.lang.String borderRightColor)
        Parameters:
        borderRightColor - Right border color.
      • getBorderDiagonal

        public java.lang.String getBorderDiagonal()
        Returns:
        Diagonal border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • setBorderDiagonal

        public void setBorderDiagonal​(java.lang.String borderDiagonal)
        Parameters:
        borderDiagonal - Diagonal border style : dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]
      • getBorderDiagonalDirection

        public java.lang.String getBorderDiagonalDirection()
        Returns:
        Direction of the diagonal border : [up-wards|down-wards| both]
      • setBorderDiagonalDirection

        public void setBorderDiagonalDirection​(java.lang.String borderDiagonalDirection)
        Parameters:
        borderDiagonalDirection - Direction of the diagonal border : [up-wards|down-wards| both]
      • getBorderDiagonalColor

        public java.lang.String getBorderDiagonalColor()
        Returns:
        Color of the diagonal border.
      • setBorderDiagonalColor

        public void setBorderDiagonalColor​(java.lang.String borderDiagonalColor)
        Parameters:
        borderDiagonalColor - Color of the diagonal border.
      • getTextHAlignment

        public java.lang.String getTextHAlignment()
        Returns:
        Horizontal text alignment : [top|bottom|center|justify]
      • setTextHAlignment

        public void setTextHAlignment​(java.lang.String textHAlignment)
        Parameters:
        textHAlignment - Horizontal text alignment : [top|bottom|center|justify]
      • getTextVAlignment

        public java.lang.String getTextVAlignment()
        Returns:
        Vertical text alignment.
      • setTextVAlignment

        public void setTextVAlignment​(java.lang.String textVAlignment)
        Parameters:
        textVAlignment - Vertical text alignment.
      • getTextRotation

        public java.lang.Integer getTextRotation()
        Returns:
        Rotation of the text.
      • setTextRotation

        public void setTextRotation​(java.lang.Integer textRotation)
        Parameters:
        textRotation - Rotation of the text.
      • getJSON

        public com.google.gson.JsonObject getJSON()
        Specified by:
        getJSON in class CellStyle
        Returns:
        JSONObject with the tags for this tableCell for the Cloud Office Print server.