[
https://issues.apache.org/jira/browse/NIFI-13304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850123#comment-17850123
]
Philipp Korniets edited comment on NIFI-13304 at 5/28/24 6:15 PM:
------------------------------------------------------------------
Thinking about it - if there are two different sets of columns in two sheets -
we can't really use QueryRecord or Partition.
Trick with sheet name - duplicating flowfiles - not a nice solution. Looks more
like a hack..
The workaround is update attribute + retry
But simple and easy ConvertExcelToCSV is much better
was (Author: iiojj2):
Thinking about it - if there are two different sets of columns in two she - we
can't really use QueryRecord or Partition.
Trick with sheet name - duplicating flowfiles - not a nice solution. Looks more
like a hack..
The workaround is update attribute + retry
But simple and easy ConvertExcelToCSV is much better
> 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)
