Package org.openxava.util.jxls

Class JxlsStyle

java.lang.Object
org.openxava.util.jxls.JxlsStyle
All Implemented Interfaces:
JxlsConstants
public class JxlsStyle extends Object implements JxlsConstants
JxlsStyle: a class to wrap and simplify the use of Apache POI CellStyle in the context of OpenXava Principle: JxlsStyle should not be instantiated directly, but rather created through workbook.addStyle(style) each setProperty returns the style so the setProperty's can be chained Usage: JxlsWorkbook wb = new JxlsWorkbook("Test"); JxlsSheet sheet = wb.addSheet("Test"); JxlsStyle boldCenteredTextS = wb.addStyle(TEXT).setAlign(CENTER).setBold(); JxlsStyle boldCenteredTextBorderedS = wb.addClonedStyle(boldCenteredTextS).setBorder(BOTTOM, BORDER_THIN); sheet.setValue(3, 4, "Pi", boldCenteredTextS); sheet.setValue(4, 4, "Pi", boldCenteredTextBorderedS);
Author:
Laurent Wibaux

  • Field Details

    • cellStyle

      protected org.apache.poi.ss.usermodel.CellStyle cellStyle

  • Constructor Details

  • Method Details

    • clone

      protected JxlsStyle clone(JxlsWorkbook workbook, String name)

    • setFontName

      public JxlsStyle setFontName(String fontName)
      Sets the font name to use in this style
      Parameters:
      fontName - the name of the font
      Returns:
      the style to chain other settings

    • setFontSize

      public JxlsStyle setFontSize(int fontSize)
      Sets the font size to use in this style
      Parameters:
      fontSize - the size in points of the font
      Returns:
      the style to chain other settings

    • setFormat

      public JxlsStyle setFormat(String format)
      Sets the format to use to display numbers using this style
      Parameters:
      format - the format encoded as per xls
      Returns:
      the style to chain other settings

    • setBold

      public JxlsStyle setBold()
      Make the cell using this style bold
      Returns:
      the style to chain other settings

    • setWrap

      public JxlsStyle setWrap(boolean wraps)
      Make the cell wraps its content
      Returns:
      the style to chain other settings

    • setBold

      public JxlsStyle setBold(boolean isBold)
      Make the cell using this style bold or not
      Parameters:
      isBold - true to set bold, false otherwise
      Returns:
      the style to chain other settings

    • setTextColor

      public JxlsStyle setTextColor(short textColor)
      Sets the color to use to render the writing of the cell
      Parameters:
      textColor - the color (one of JxlsConstants color, or one of HSSFColor.color.index)
      Returns:
      the style to chain other settings

    • setCellColor

      public JxlsStyle setCellColor(short bgColor)
      Sets the color to use to render the background of the cell
      Parameters:
      bgColor - the color (one of JxlsConstants color, or one of HSSFColor.?.index)
      Returns:
      the style to chain other settings

    • setAlign

      public JxlsStyle setAlign(short align)
      Sets the justification to use to render the content of the cell
      Parameters:
      align - the alignment (one of LEFT, CENTER, RIGHT)
      Returns:
      the style to chain other settings

    • setBorders

      public JxlsStyle setBorders(short top, short bottom, short left, short right)
      Sets the borders for the 4 sides of the cell
      Parameters:
      top - the border to use at the top (one of BORDER_NONE, BORDER_THIN, BORDER_THICK or CellStyle.BORDER_?)
      bottom - the border to use at the bottom
      left - the border to use at the left
      right - the border to use at the right
      Returns:
      the style to chain other settings

    • setBorder

      public JxlsStyle setBorder(short place, short borderStyle)
      Sets the borders for some of the sides of the cell
      Parameters:
      place - the borders to sets (TOP, TOP+LEFT, TOP+BOTTOM...)
      borderStyle - the border style to use (one of BORDER_NONE, BORDER_THIN, BORDER_THICK or CellStyle.BORDER_?)
      Returns:
      the style to chain other settings

    • setBorderColor

      public JxlsStyle setBorderColor(short borderColor)
      Sets the border color for the 4 sides of the cell
      Parameters:
      borderColor - the color (one of JxlsConstants color, or one of HSSFColor.color.index)
      Returns:
      the style to chain other settings

    • createPOICellStyle

      protected void createPOICellStyle(JxlsWorkbook workbook, org.apache.poi.ss.usermodel.Workbook poiWorkbook)