[
https://issues.apache.org/jira/browse/NIFI-16336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18118560#comment-18118560
]
Daniel Stieglitz edited comment on NIFI-16336 at 9/23/26 7:22 PM:
------------------------------------------------------------------
[~iiojj2] I am about to submit a PR. With the fix I have added, now the output
from the example attached is
{code:java}
ID,Last Update,Trade Date,Settlement Date,Expiry Date,Bloomberg
Code,ISIN,Security Code,Swap Type,Multiplier,Original Qty
And here goes some huge long disclaimer from the bank. This is not part of data
im interested in,,,,,,,,,,
{code}
Sorry but in Jira the column names are wrapping but they all are really one one
line.
In addition no exceptions are thrown if field values cannot be inferred as they
will default to being strings.
was (Author: JIRAUSER294662):
[~iiojj2] I am about to submit a PR but now I have the output from the example
attached as
{code:java}
ID,Last Update,Trade Date,Settlement Date,Expiry Date,Bloomberg
Code,ISIN,Security Code,Swap Type,Multiplier,Original Qty
And here goes some huge long disclaimer from the bank. This is not part of data
im interested in,,,,,,,,,,
{code}
Sorry but in Jira the column names are wrapping but they all are really one one
line.
In addition no exceptions are thrown if field values cannot be inferred as they
will default to being strings.
> 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
> Assignee: Daniel Stieglitz
> 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)
