Vinz2168 opened a new pull request, #11783: URL: https://github.com/apache/nifi/pull/11783
# Summary [NIFI-16443](https://issues.apache.org/jira/browse/NIFI-16443) Adds an optional `Ignore Cells Beyond Header` property to `ExcelReader`, visible only with the `Use Starting Row` schema access strategy. It defaults to `false`, so the current behavior is unchanged. When enabled, cells beyond the last header column are ignored during schema inference instead of failing with `Row N has X cells, more than the expected Y number of field names`. Blank cells, whitespace-only strings and formulas evaluating to an empty string are ignored silently. When ignored cells contain a value, a single warning per sheet is logged with the number of affected rows and the first position, so data is never dropped silently. Only the rows evaluated according to the `Row Evaluation Strategy` are checked. `ExcelRecordReader` is unchanged, as it already handles cells beyond the schema fields. # Tracking ### Issue Tracking - [x] [Apache NiFi Jira](https://issues.apache.org/jira/browse/NIFI) issue created ### Pull Request Tracking - [x] Pull Request title starts with Apache NiFi Jira issue number, such as `NIFI-00000` - [x] Pull Request commit message starts with Apache NiFi Jira issue number, as such `NIFI-00000` - [x] Pull request contains [commits signed](https://docs.github.com/en/authentication/managing-commit-signature-verification/signing-commits) with a registered key indicating `Verified` status ### Pull Request Formatting - [x] Pull Request based on current revision of the `main` branch - [x] Pull Request refers to a feature branch with one commit containing changes # Verification ### Build - [ ] Build completed using `./mvnw clean install -P contrib-check` - [ ] JDK 21 - [ ] JDK 25 ### Licensing - [ ] New dependencies are compatible with the [Apache License 2.0](https://apache.org/licenses/LICENSE-2.0) according to the [License Policy](https://www.apache.org/legal/resolved.html) - [ ] New dependencies are documented in applicable `LICENSE` and `NOTICE` files ### Documentation - [x] Documentation formatting appears as expected in rendered files -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
