[
https://issues.apache.org/jira/browse/NIFI-14509?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948948#comment-17948948
]
David Handermann commented on NIFI-14509:
-----------------------------------------
The {{Value Separator}} example is an edge case for that particular property,
and it is also more straightforward to handle as a string, versus a number.
For the Starting Row strategy, I don't think falling back to the default value
should be supported, because an Expression Language statement that can
sometimes be invalid indicates a flow configuration that needs to be changed.
> ExcelReader - Starting Row default value
> ----------------------------------------
>
> Key: NIFI-14509
> URL: https://issues.apache.org/jira/browse/NIFI-14509
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 2.3.0
> Reporter: Philipp Korniets
> Priority: Minor
> Attachments: image-2025-05-02-14-39-18-581.png
>
>
> If Starting Row in Excel reader is set to use flowfile attribute (i.e.
> ${startRow}) and attribute is missing ExcelReader throws an error message
> {code:java}
> java.lang.NumberFormatException: For input string: ""
> at
> java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:67)
> at java.base/java.lang.Integer.parseInt(Integer.java:672)
> at java.base/java.lang.Integer.parseInt(Integer.java:778)
> at
> org.apache.nifi.attribute.expression.language.StandardPropertyValue.asInteger(StandardPropertyValue.java:88){code}
> Of course we can use
> {code:java}
> ${startRow:isNull():ifElse(1,${startRow})}{code}
> But it would be nice to go back to defaults if attribute is missing.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
