[jira] [Resolved] (NIFI-11989) ConvertExcelToCSVProcessor conversion will lose data if header line of xlsx file contains empty merged cells

["Pierre Villard (Jira)" <ji...@apache.org>]

     [ 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)