Package bld.generator.report.excel.annotation

Annotation Type ExcelCellLayout

@Documented @Retention(RUNTIME) @Target(FIELD) public @interface ExcelCellLayout
The Interface ExcelCellLayout.
ExcelCellLayout is used to define the cell style.
The cell style is composed by:
  • Border - to set borders types
  • HorizontalAlignment - to set horizontal align
  • VerticalAlignment - to set vertical align
  • Font - to set font type
  • wrap - to enable/disable wrap text into cell
  • rgbFont - to set the font color
  • rgbForeground - to set the background color
  • fillPatternType - to set fill pattern style
  • precision - to set the precision number, if the value is not a number then it is ignored
  • locked - to enable/disable edit cell
It is set on:

  • Element Details

    • border

      ExcelBorder border
      Border.
      Returns:
      the excel border
      Default:
      @bld.generator.report.excel.annotation.ExcelBorder(top=THIN, bottom=THIN, left=THIN, right=THIN)

    • horizontalAlignment

      org.apache.poi.ss.usermodel.HorizontalAlignment horizontalAlignment
      Horizontal alignment.
      Returns:
      the horizontal alignment
      Default:
      LEFT

    • verticalAlignment

      org.apache.poi.ss.usermodel.VerticalAlignment verticalAlignment
      Vertical alignment.
      Returns:
      the vertical alignment
      Default:
      CENTER

    • font

      ExcelFont font
      Font.
      Returns:
      the excel font
      Default:
      @bld.generator.report.excel.annotation.ExcelFont

    • wrap

      boolean wrap
      Wrap.
      Returns:
      true, if successful
      Default:
      true

    • rgbFont

      ExcelRgbColor[] rgbFont
      Rgb font.
      Returns:
      the excel rgb color
      RgbFont is an array for alternating font colors between rows through the following expression:
      numberRow mod sizeArray
      Default:
      {@bld.generator.report.excel.annotation.ExcelRgbColor(red=(byte)0x00, green=(byte)0x00, blue=(byte)0x00)}

    • rgbForeground

      ExcelRgbColor[] rgbForeground
      Rgb foreground.
      Returns:
      the excel rgb color
      RgbForeground is an array for alternating foreground colors between rows through the following expression:
      numberRow mod sizeArray
      Default:
      {@bld.generator.report.excel.annotation.ExcelRgbColor(red=(byte)0xff, green=(byte)0xff, blue=(byte)0xff)}

    • fillPatternType

      org.apache.poi.ss.usermodel.FillPatternType fillPatternType
      Fill pattern type.
      Returns:
      the fill pattern type
      Default:
      SOLID_FOREGROUND

    • precision

      int precision
      Precision.
      Returns:
      the int
      Default:
      -1

    • percent

      boolean percent
      Default:
      false

    • locked

      boolean locked
      Locked.
      Returns:
      true, if successful
      Default:
      false

    • autoSizeColumn

      boolean autoSizeColumn
      Auto size column.
      Returns:
      true, if successful
      Default:
      false