Class WorkbookUtils
java.lang.Object
com.palantir.transforms.excel.utils.WorkbookUtils
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 Summary
Modifier and TypeMethodDescriptionstatic org.apache.poi.ss.util.CellAddressgetAddressOfMergedCell(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellAddress cellAddress) getCellValuesIncludingNulls(org.apache.poi.ss.usermodel.Row row, int startCellNum, int endCellNum, NumericCellStringifier numericCellStringifier) getCellValuesIncludingNullsRespectingMerges(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.usermodel.Row row, int startCellNum, int endCellNum) static StringgetValueAsString(org.apache.poi.ss.usermodel.Cell cell) static StringgetValueAsString(org.apache.poi.ss.usermodel.Cell cell, NumericCellStringifier stringifier)
-
Method Details
-
getValueAsString
-
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
-
getAddressOfMergedCell
public static org.apache.poi.ss.util.CellAddress getAddressOfMergedCell(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellAddress cellAddress)
-