[
https://issues.apache.org/jira/browse/NIFI-4112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16077581#comment-16077581
]
ASF GitHub Bot commented on NIFI-4112:
--------------------------------------
Github user ijokarumawak commented on a diff in the pull request:
https://github.com/apache/nifi/pull/1973#discussion_r126069842
--- Diff:
nifi-nar-bundles/nifi-poi-bundle/nifi-poi-processors/src/test/resources/with-blank-cells.csv
---
@@ -0,0 1,8 @@
A,B,C,D
--- End diff --
@m-hogue Thanks for your comment! If a row only contains empty cells, then
it will be ignored. Since we're processing an Excel sheet as an XML document,
such row wouldn't be passed to our code. Excel XML only contains rows and cells
those have values.
> ConvertExceltoCSV removes missing cells
> ---------------------------------------
>
> Key: NIFI-4112
> URL: https://issues.apache.org/jira/browse/NIFI-4112
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.3.0
> Reporter: Michael Boulter
> Assignee: Koji Kawamura
> Priority: Minor
> Attachments: 4146786940134586_Sheet1.csv, test.xlsx
>
>
> The ConvertExceltoCSV will remove missing cells from the CSV output.
> An input of {{TEST,,,TEST}} will become {{TEST,TEST}}
> Please see input and output attached.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
