[
https://issues.apache.org/jira/browse/NIFI-11989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Villard resolved NIFI-11989.
-----------------------------------
Resolution: Feedback Received
Apache NiFi 1.x is no longer maintained and no new release is planned on the
1.x release line. Marking as resolved as part of a cleanup operation. Please
open a new one with an updated description if this is still relevant for NiFi
2.x.
> ConvertExcelToCSVProcessor conversion will lose data if header line of xlsx
> file contains empty merged cells
> ------------------------------------------------------------------------------------------------------------
>
> Key: NIFI-11989
> URL: https://issues.apache.org/jira/browse/NIFI-11989
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.23.2
> Environment: Linux hb3-prod-hadoop-000 4.18.0-477.13.1.el8_8.x86_64
> #1 SMP Tue May 30 14:53:41 EDT 2023 x86_64 x86_64 x86_64 GNU/Linux
> Reporter: macdoor615
> Priority: Major
> Attachments: header line with empty merged cell-1.xlsx, header line
> with empty merged cell.csv, header line with empty merged cell.xlsx, header
> line without empty merged cell.csv
>
>
> In the "header line with empty merged cell-1.xlsx" file, above the cells with
> contents "ca" and "cb" is an empty merged cell.
> Convert the "header line with empty merged cell-1.xlsx" file with
> ConvertExcelToCSVProcessor.
> The output csv file "header line with empty merged cell.csv" loses the
> content of the column after the empty merged cell, the content of the "dd"
> and ''ff" cells and the following cells are gone.
> As a comparison of the xlsx file, the merged cell has content, and the
> content is "c", so the subsequent columns will not be lost.
> The output is in the "header line without empty merged cell.csv" file
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
