Class Cell

    • Constructor Detail

      • Cell

        public Cell​(Column column,
                    List<String> displayValues)
        Init a new Cell for a Column with multiple display values and no sort values.
        Parameters:
        column - Column for the cell
        displayValues - List of string output values
      • Cell

        public Cell​(Column column,
                    List<String> displayValues,
                    List<String> sortValues)
        Init a new Cell for a Column with mulitple values in a cell.
        Parameters:
        column - Column for the cell
        displayValues - List of string output values
        sortValues - List of string sort values
      • Cell

        public Cell​(Column column,
                    String displayValue)
        Init a Cell for a Column with single value in cell with no sort value.
        Parameters:
        column - Column for the cell
        displayValue - String output value
      • Cell

        public Cell​(Column column,
                    String displayValue,
                    String sortValue)
        Init a Cell for a Column with single value in cell.
        Parameters:
        column - Column for the cell
        displayValue - String ouput value
        sortValue - String sort value
    • Method Detail

      • getCellColor

        public org.apache.poi.ss.usermodel.IndexedColors getCellColor()
        Get the cell background color for this cell in an XLSX workbook.
        Returns:
        IndexedColors value for cell
      • getCellPattern

        public org.apache.poi.ss.usermodel.FillPatternType getCellPattern()
        Get the cell background pattern for this cell in an XLSX workbook.
        Returns:
        FillPatternType value for cell
      • getColumnName

        public String getColumnName()
        Get the column name for a cell. This returns the display name, including any rendering tags.
        Returns:
        String column name
      • getComment

        public String getComment()
        Get the comment for this Cell.
        Returns:
        String comment, or null
      • getDisplayValues

        public List<String> getDisplayValues()
        Get the value of a cell.
        Returns:
        String value
      • getHTMLClass

        public String getHTMLClass()
        Get the HTML class of a cell.
        Returns:
        String HTML bootstrap class, or null
      • getHref

        public String getHref()
        Get an href link for the cell or null.
        Returns:
        String link or null
      • getFontColor

        public org.apache.poi.ss.usermodel.IndexedColors getFontColor()
        Get the font color for this cell in an XLSX workbook.
        Returns:
        IndexedColors value for font
      • getSortValueString

        public String getSortValueString()
        Get the sort value of a cell.
        Returns:
        String value
      • setCellColor

        public void setCellColor​(org.apache.poi.ss.usermodel.IndexedColors cellColor)
        Set the cell background color for this cell in an XLSX workbook.
        Parameters:
        cellColor - IndexedColors value for cell
      • setCellPattern

        public void setCellPattern​(org.apache.poi.ss.usermodel.FillPatternType cellPattern)
        Set the cell background pattern for this cell in an XLSX workbook.
        Parameters:
        cellPattern - FillPatternType value for this cell
      • setComment

        public void setComment​(String comment)
        Add a comment to this Cell.
        Parameters:
        comment - String comment
      • setHref

        public void setHref​(String href)
        Add a link to this Cell.
        Parameters:
        href - String href link
      • setHTMLClass

        public void setHTMLClass​(String htmlClass)
        Add an HTML class to this Cell.
        Parameters:
        htmlClass - String Bootstrap HTML class
      • setFontColor

        public void setFontColor​(org.apache.poi.ss.usermodel.IndexedColors fontColor)
        Set the font color for this cell in an XLSX workbook.
        Parameters:
        fontColor - IndexedColors value for font