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 Details

    • FONT_SIZE

      protected static final short FONT_SIZE
      See Also:
      Constant Field Values

    • 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.