[
https://issues.apache.org/jira/browse/NIFI-16336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philipp Korniets updated NIFI-16336:
------------------------------------
Description:
ConvertRecord with ExcelReader and CSVRecordWriter with below setup:
sheetName=Valuation
startingRow = 5
Test book: [^TestBook_20261109.xlsx]
Expect - either no flowfile to be generated or flowfile with full header row
and some value in the 3rd row in ID field.
However it skips all the headers except ID - because this is the only field
which has value within 10 rows. (Row Evaluation Strategy)
!image-2026-09-11-14-31-21-487.png|width=476,height=383!
!image-2026-09-11-14-34-34-432.png|width=467,height=167!
This behaviour breaks downstream processes like queryRecord which relies on
presence of certain fields.
There is a workaround to check the schema etc... but its different from the
behaviour we had in ConvertExcelToCSV processor.
was:
ConvertRecord with ExcelReader with below setup:
sheetName=Valuation
startingRow = 5
Expect - either no flowfile to be generated or flowfile with full header row
and some value in the 3rd row in ID field.
However it skips all the headers except ID - because this is the only field
which has value within 10 rows. (Row Evaluation Strategy)
!image-2026-09-11-14-31-21-487.png|width=476,height=383!
!image-2026-09-11-14-34-34-432.png|width=467,height=167!
This behaviour breaks downstream processes like queryRecord which relies on
presence of certain fields.
There is a workaround to check the schema etc... but its different from the
behaviour we had in ConvertExcelToCSV processor.
> ExcelReader - empty files with footer
> -------------------------------------
>
> Key: NIFI-16336
> URL: https://issues.apache.org/jira/browse/NIFI-16336
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: nifi-api-2.11.0
> Reporter: Philipp Korniets
> Priority: Major
> Attachments: TestBook_20261109.xlsx,
> image-2026-09-11-14-31-21-487.png, image-2026-09-11-14-34-34-432.png
>
>
> ConvertRecord with ExcelReader and CSVRecordWriter with below setup:
> sheetName=Valuation
> startingRow = 5
> Test book: [^TestBook_20261109.xlsx]
> Expect - either no flowfile to be generated or flowfile with full header row
> and some value in the 3rd row in ID field.
> However it skips all the headers except ID - because this is the only field
> which has value within 10 rows. (Row Evaluation Strategy)
> !image-2026-09-11-14-31-21-487.png|width=476,height=383!
>
> !image-2026-09-11-14-34-34-432.png|width=467,height=167!
>
> This behaviour breaks downstream processes like queryRecord which relies on
> presence of certain fields.
> There is a workaround to check the schema etc... but its different from the
> behaviour we had in ConvertExcelToCSV processor.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
