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.CellAddress
getAddressOfMergedCell
(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 String
getValueAsString
(org.apache.poi.ss.usermodel.Cell cell) static String
getValueAsString
(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)
-