Enum Class ExcelReader.FailedExpressionStrategy
java.lang.Object
java.lang.Enum<ExcelReader.FailedExpressionStrategy>
com.northconcepts.datapipeline.excel.ExcelReader.FailedExpressionStrategy
- All Implemented Interfaces:
Serializable,Comparable<ExcelReader.FailedExpressionStrategy>,Constable
- Enclosing class:
ExcelReader
public static enum ExcelReader.FailedExpressionStrategy
extends Enum<ExcelReader.FailedExpressionStrategy>
Indicates how to handle failures when evaluating cell formulas/expressions.
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionThrow exception when cell formula/expression evaluation fails -- causing the pipeline/job to abort.Use the last value cached in the Excel spreadsheet when cell formula/expression evaluation fails if available.Use the failure's exception message as the field's value when a cell formula evaluation fails.Use the formula/expression as the field's value when a cell formula evaluation fails.Usenullas the field's value when a cell formula evaluation fails. -
Method Summary
Modifier and TypeMethodDescriptionLooks up a FailedExpressionStrategy by name (case-insensitive).Returns the enum constant of this class with the specified name.static ExcelReader.FailedExpressionStrategy[]values()Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
FAIL
Throw exception when cell formula/expression evaluation fails -- causing the pipeline/job to abort. -
SET_CACHED_VALUE
Use the last value cached in the Excel spreadsheet when cell formula/expression evaluation fails if available. -
SET_EXPRESSION
Use the formula/expression as the field's value when a cell formula evaluation fails. -
SET_NULL
Usenullas the field's value when a cell formula evaluation fails. -
SET_EXCEPTION_MESSAGE
Use the failure's exception message as the field's value when a cell formula evaluation fails.
-
-
Method Details
-
values
Returns an array containing the constants of this enum class, in the order they are declared.- Returns:
- an array containing the constants of this enum class, in the order they are declared
-
valueOf
Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)- Parameters:
name- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException- if this enum class has no constant with the specified nameNullPointerException- if the argument is null
-
lookup
Looks up a FailedExpressionStrategy by name (case-insensitive).- Parameters:
name- the name of the strategy to lookup- Returns:
- the matching FailedExpressionStrategy, or null if not found or name is empty
-