Package org.spdx.tools.compare

Class AbstractSheet

java.lang.Object
org.spdx.tools.compare.AbstractSheet
Direct Known Subclasses:
AbstractFileCompareSheet, CreatorSheet, DocumentAnnotationSheet, DocumentRelationshipSheet, DocumentSheet, ExternalReferencesSheet, ExtractedLicenseSheet, PackageSheet, SnippetSheet, VerificationSheet
public abstract class AbstractSheet extends Object
Abstract class representing a workbook sheet used in storing structured data
Author:
Gary O'Neall

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected org.apache.poi.ss.usermodel.CellStyle
    checkboxStyle
     
    protected org.apache.poi.ss.usermodel.CellStyle
    dateStyle
     
    protected int
    firstCellNum
     
    protected int
    firstRowNum
     
    protected static final short
    FONT_SIZE
     
    protected org.apache.poi.ss.usermodel.CellStyle
    greenWrapped
     
    protected int
    lastRowNum
     
    protected org.apache.poi.ss.usermodel.CellStyle
    redWrapped
     
    protected org.apache.poi.ss.usermodel.Sheet
    sheet
     
    protected org.apache.poi.ss.usermodel.Workbook
    workbook
     
    protected org.apache.poi.ss.usermodel.CellStyle
    yellowWrapped
     

  • Constructor Summary

    Constructors
    Constructor
    Description
    AbstractSheet(org.apache.poi.ss.usermodel.Workbook workbook, String sheetName)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    protected org.apache.poi.ss.usermodel.Row
    addRow()
    Add a new row to the end of the sheet
    void
    clear()
    Clears all data from the worksheet
    static org.apache.poi.ss.usermodel.CellStyle
    createCenterStyle(org.apache.poi.ss.usermodel.Workbook wb)
     
    static org.apache.poi.ss.usermodel.CellStyle
    createHeaderStyle(org.apache.poi.ss.usermodel.Workbook wb)
     
    static org.apache.poi.ss.usermodel.CellStyle
    createLeftWrapStyle(org.apache.poi.ss.usermodel.Workbook wb)
     
    int
    getFirstDataRow()
     
    int
    getNumDataRows()
     
    org.apache.poi.ss.usermodel.Sheet
    getSheet()
     
    void
    resizeRows()
    resize the rows for a best fit.
    abstract String
    verify()
     

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Field Details

    • FONT_SIZE

      protected static final short FONT_SIZE
      See Also:

    • checkboxStyle

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

    • dateStyle

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

    • greenWrapped

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

    • redWrapped

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

    • yellowWrapped

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

    • workbook

      protected org.apache.poi.ss.usermodel.Workbook workbook

    • sheet

      protected org.apache.poi.ss.usermodel.Sheet sheet

    • lastRowNum

      protected int lastRowNum

    • firstCellNum

      protected int firstCellNum

    • firstRowNum

      protected int firstRowNum

  • Constructor Details

    • AbstractSheet

      public AbstractSheet(org.apache.poi.ss.usermodel.Workbook workbook, String sheetName)
      Parameters:
      workbook -
      sheetName -

  • Method Details

    • addRow

      protected org.apache.poi.ss.usermodel.Row addRow()
      Add a new row to the end of the sheet
      Returns:
      new row

    • clear

      public void clear()
      Clears all data from the worksheet

    • getFirstDataRow

      public int getFirstDataRow()

    • getNumDataRows

      public int getNumDataRows()

    • getSheet

      public org.apache.poi.ss.usermodel.Sheet getSheet()

    • verify

      public abstract String verify()

    • createHeaderStyle

      public static org.apache.poi.ss.usermodel.CellStyle createHeaderStyle(org.apache.poi.ss.usermodel.Workbook wb)

    • createLeftWrapStyle

      public static org.apache.poi.ss.usermodel.CellStyle createLeftWrapStyle(org.apache.poi.ss.usermodel.Workbook wb)

    • createCenterStyle

      public static org.apache.poi.ss.usermodel.CellStyle createCenterStyle(org.apache.poi.ss.usermodel.Workbook wb)

    • resizeRows

      public void resizeRows()
      resize the rows for a best fit. Will not exceed maximum row height.