Class WorkbookUtils

java.lang.Object
com.palantir.transforms.excel.utils.WorkbookUtils

public final class WorkbookUtils extends Object
Functions that are generally convenient when working with Workbook objects.

In addition to being used by this library internally, consumers of this library who provide custom implementation classes for interfaces like StopCondition and ValueExtractor should find these functions useful.

See Also:
  • Method Details

    • getValueAsString

      @Nullable public static String getValueAsString(org.apache.poi.ss.usermodel.Cell cell)
    • getValueAsString

      @Nullable public static String getValueAsString(org.apache.poi.ss.usermodel.Cell cell, NumericCellStringifier stringifier)
    • getCellValuesIncludingNulls

      public static List<String> getCellValuesIncludingNulls(org.apache.poi.ss.usermodel.Row row, int startCellNum, int endCellNum, NumericCellStringifier numericCellStringifier)
    • getCellValuesIncludingNullsRespectingMerges

      public static List<String> getCellValuesIncludingNullsRespectingMerges(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Row row, int startCellNum, int endCellNum)
    • getAddressOfMergedCell

      public static org.apache.poi.ss.util.CellAddress getAddressOfMergedCell(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellAddress cellAddress)