Class XlsxText

All Implemented Interfaces:
Serializable, XlsxElement, Identified

@Component public class XlsxText extends XlsxComponent implements XlsxElement, Identified
This class extends XlsxComponent and implements Identified and implements XlsxElement.
This class allows to add a text inside a cell given a row and a column.
See Also:
  • Field Details

  • Constructor Details

    • XlsxText

      public XlsxText()
  • Method Details

    • getIdentity

      public Identity getIdentity()
      Description copied from interface: Identified
      Returns the Identity associated to the component
      Specified by:
      getIdentity in interface Identified
      Overrides:
      getIdentity in class XlsxComponent
      Returns:
      The Identity of the user currently logged in the application
    • setIdentity

      public void setIdentity(Identity identity)
      Description copied from interface: Identified
      Sets the Identity to the component
      Specified by:
      setIdentity in interface Identified
      Overrides:
      setIdentity in class XlsxComponent
      Parameters:
      identity - The Identity that must be associated to the component
    • setROW

      public void setROW(String s)
      Sets the row.
      Parameters:
      s - The row to set.
    • setCOL

      public void setCOL(String s)
      Sets the column.
      Parameters:
      s - The column to set.
    • setROWSPAN

      public void setROWSPAN(String s)
      Sets the row span.
      Parameters:
      s - The row span to set.
    • setCOLSPAN

      public void setCOLSPAN(String s)
      Sets the column span.
      Parameters:
      s - The column span to set.
    • setTEXT

      public void setTEXT(String s)
      Sets the cell's text.
      Parameters:
      s - The text to set.
    • setSIZE

      public void setSIZE(String s)
      Set the text's size.
      Parameters:
      s - The size to set.
    • setTYPE

      public void setTYPE(String type)
      Sets the cell's type.
      Parameters:
      type - The text's type to set.
    • setType

      public void setType(int type)
    • setText

      public void setText(String s)
      Sets the cell's text.
      Parameters:
      s - The text to set.
    • getOccupationRow

      public int getOccupationRow()
      Specified by:
      getOccupationRow in interface XlsxElement
    • getOccupationCol

      public int getOccupationCol()
      Specified by:
      getOccupationCol in interface XlsxElement
    • getContent

      public void getContent(org.apache.poi.ss.usermodel.Sheet sheet, int startRow, int startCol) throws Exception
      Creates a Cell with specific style and format. Th cell could be a formula Cell or simply text cell.
      If Cell has a rowspan or a colspan, the range area of the cell is bigger and takes into account all the cells that must be merged into one cell.
      Specified by:
      getContent in interface XlsxElement
      Parameters:
      sheet - The Excel sheet,
      startRow - Starting area row of the cell.
      startCol - Starting area Col of the cell.
      Throws:
      Exception - should not happend.