[
https://issues.apache.org/jira/browse/NIFI-13304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850107#comment-17850107
]
David Handermann commented on NIFI-13304:
-----------------------------------------
[~dstiegli1] As you noted, ExcelReader itself does not create FlowFiles, so it
is not capable of splitting based on sheet in the current design.
The QueryRecord Processor could be used to effectively split input spreadsheets
if each sheet had a distinguishable column that could be referenced in a SQL
query. That isn't a completely dynamic solution either, but it would work for
spreadsheets of expected formats.
> ExcelReader - ability to split into flowfile per sheet
> ------------------------------------------------------
>
> Key: NIFI-13304
> URL: https://issues.apache.org/jira/browse/NIFI-13304
> Project: Apache NiFi
> Issue Type: New Feature
> Reporter: Philipp Korniets
> Priority: Major
>
> Currently ConvertExcelToCSV processor, if processing excel with multiple
> required sheets in it, produces flowfile per sheet.
> New ExcelReader produces one flowfile with all data in it
>
> There should be a way to configure output to be sheet-per-flowfile
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
