[ 
https://issues.apache.org/jira/browse/NIFI-14264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Philipp Korniets updated NIFI-14264:
------------------------------------
    Description: 
Hi

observing strange behaviour of ExcelReader and SplitExcel

Workbook  example [^Excel Test2.xlsx]
Flow 
!image-2025-02-13-11-16-07-111.png!

 

Convert to CSV.
ExcelReader  - Schema Access Strategy - Use Starting Row

No matter how we set up ExcelRerader/CSVReader Date Format- dates in resulted 
CSV look like Excel dates after SplitExcel
{code:java}
date,Something,Name
45689,test1,Sheet1
45334,test2,Sheet1{code}
 

  was:
Hi

observing strange behaviour of ExcelReader and SplitExcel



Workbook  example [^Excel Test2.xlsx]
Flow 
!image-2025-02-13-11-16-07-111.png!

 

Convert to CSV.
No matter how we set up ExcelRerader/CSVReader - dates in resulted CSV look 
like Excel dates


{code:java}
date,Something,Name
45689,test1,Sheet1
45334,test2,Sheet1{code}
 


> ExcelReader + SplitExcel - date format
> --------------------------------------
>
>                 Key: NIFI-14264
>                 URL: https://issues.apache.org/jira/browse/NIFI-14264
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Philipp Korniets
>            Priority: Major
>         Attachments: Excel Test2.xlsx, image-2025-02-13-11-16-07-111.png
>
>
> Hi
> observing strange behaviour of ExcelReader and SplitExcel
> Workbook  example [^Excel Test2.xlsx]
> Flow 
> !image-2025-02-13-11-16-07-111.png!
>  
> Convert to CSV.
> ExcelReader  - Schema Access Strategy - Use Starting Row
> No matter how we set up ExcelRerader/CSVReader Date Format- dates in resulted 
> CSV look like Excel dates after SplitExcel
> {code:java}
> date,Something,Name
> 45689,test1,Sheet1
> 45334,test2,Sheet1{code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to