Package overit.geocall.basic.ui.xlsx

Class XlsxSheet

java.lang.Object
overit.geocall.platform.ui.UINode
overit.geocall.basic.ui.xlsx.XlsxComponent
overit.geocall.basic.ui.xlsx.XlsxSheet
All Implemented Interfaces:
Serializable, Identified
@Component public class XlsxSheet extends XlsxComponent implements Identified
This class extends XlsxComponent and implements Identified.
This class represent an Excel working sheet. There can be more working sheet, in that case they must have different name and label, the title is optional.
It manages the representation of a DBView in an Excel sheet.
See Also:

  • Constructor Details

    • XlsxSheet

      public XlsxSheet()

  • Method Details

    • 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

    • 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

    • setLABEL

      public void setLABEL(String s)
      Description copied from class: XlsxComponent
      Sets the label for the instance.
      Overrides:
      setLABEL in class XlsxComponent
      Parameters:
      s - The label to set.

    • getLabel

      public String getLabel()
      Description copied from class: XlsxComponent
      Gets the label of the instance.
      Overrides:
      getLabel in class XlsxComponent
      Returns:
      The label of the instance.

    • setTITLE

      public void setTITLE(String s)
      Sets the sheet's title
      Parameters:
      s - The title to set.

    • getTitle

      public String getTitle()
      Gets the sheet's title.
      Returns:
      The sheet's title.

    • setNAME

      public void setNAME(String s)
      Description copied from class: XlsxComponent
      Sets the name for the instance.
      Overrides:
      setNAME in class XlsxComponent
      Parameters:
      s - The name to set.

    • getName

      public String getName()
      Description copied from class: XlsxComponent
      Gets the name of tbe instance.
      Overrides:
      getName in class XlsxComponent
      Returns:
      The name of the instance.

    • getEndCol

      public int getEndCol()

    • getEndRow

      public int getEndRow()

    • setTITLEWRAP

      public void setTITLEWRAP(String s)
      Sets if you want to wrap the sheet's title or not.
      Parameters:
      s - "1" if you want to wrap the title, "0" otherwise.

    • getTitleWrap

      public boolean getTitleWrap()
      Gets if the sheet's title is wrapped or not.
      Returns:
      true if the title is wrapped,false otherwise.

    • setROWPAGEBREAK

      public void setROWPAGEBREAK(String s)
      Sets the row after that the page breaks.
      Parameters:
      s - The row to set.

    • setPAGEORIENTATION

      public void setPAGEORIENTATION(String s)
      Sets the page's orientation.
      Parameters:
      s - The orientation of the page.

    • getPageOrientation

      public char getPageOrientation()
      Gets the page's orientation.
      Returns:
      The page's orientation.

    • setDISPLAYGRIDLINES

      public void setDISPLAYGRIDLINES(String s)
      Sets if the grid lines should be displayed or not.
      Parameters:
      s - true if the grid lines should be displayed, false otherwise.

    • getDisplayGridLines

      public boolean getDisplayGridLines()
      Gets if the grid lines should be displayed or not.
      Returns:
      true if the grid lines should be displayed, false otherwise.

    • setFITHEIGHT

      public void setFITHEIGHT(String s)
      Sets the page's fit height.
      Parameters:
      s - The height to set.

    • setFITWIDTH

      public void setFITWIDTH(String s)
      Sets the page's fit width.
      Parameters:
      s - The width to set.

    • setHEADERMARGIN

      public void setHEADERMARGIN(String s)
      Sets the margin for the header.
      Parameters:
      s - The margin to set.

    • setFOOTERMARGIN

      public void setFOOTERMARGIN(String s)
      Sets the margin for the footer.
      Parameters:
      s - The margin to set.

    • getSheets

      public org.apache.poi.ss.usermodel.Sheet[] getSheets(org.apache.poi.ss.usermodel.Workbook wb, int fogli)
      Gets an array containing the sheets defined by the label of the actual instance
      Parameters:
      wb - The active workbook
      fogli - Sheet number in the workbook.
      Returns:
      A Sheet array containing the sheets defined by the label of the actual instance.

    • giveSheet

      protected org.apache.poi.ss.usermodel.Sheet giveSheet(org.apache.poi.ss.usermodel.Sheet sheet)

    • setDataView

      public void setDataView(Object dbv)
      Sets the DataView into the active sheet.
      Parameters:
      dbv - The DataView to set.

    • setDataView

      public void setDataView(Object dbv, String name)
      Sets the DataView into a specific table in the active sheet.
      Parameters:
      dbv - The DataView to set.
      name - The table in which insert the Data View.

    • getTableView

      public XlsxTableView getTableView(String name)
      Gets the XlsxTableView defined by name passed by parameter.
      Parameters:
      name - The table view's name.
      Returns:
      The XlsxTableView defined by name passed by parameter.

    • addTitle

      protected void addTitle(String title, org.apache.poi.ss.usermodel.Sheet sheet)

    • addChild

      public void addChild(UINode n)
      Description copied from class: UINode
      Empty method
      Overrides:
      addChild in class UINode
      Parameters:
      n - Not used

    • setPAGEMARGIN

      public void setPAGEMARGIN(String s)
      Sets the page's margin.
      Parameters:
      s - The margin to set.

    • setTitle

      public void setTitle(String s)

    • setLabel

      public void setLabel(String s)
      Overrides:
      setLabel in class XlsxComponent