[
https://issues.apache.org/jira/browse/NIFI-14265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philipp Korniets updated NIFI-14265:
------------------------------------
Description:
Hi
observing strange behaviour of ExcelReader
Workbook example [^Excel Test2.xlsx]
Flow
!image-2025-02-13-11-54-45-830.png|width=1730,height=187!
Convert to CSV.
ExcelReader -
!image-2025-02-13-11-55-19-478.png|width=507,height=329!
CSVRecordSetWriter
!image-2025-02-13-11-57-55-829.png|width=505,height=455!
if we dont have attribute ${sheetName} ExcelReader combines all sheets together
(as expected) however the date stays in milliseconds
{code:java}
date,Something,Name
1738368000000,test1,Sheet1
1707696000000,test2,Sheet1
211248000000,aaa,Sheet2
540086400000,sss,Sheet2
{code}
If you provide sheet name - date formatted correctly
{code:java}
date,Something,Name
2025-02-01,test1,Sheet1
2024-02-12,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.
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}
> ExcelReader - date stays in milliseconds
> -----------------------------------------
>
> Key: NIFI-14265
> URL: https://issues.apache.org/jira/browse/NIFI-14265
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 2.0.0
> Reporter: Philipp Korniets
> Priority: Major
> Attachments: Excel Test2.xlsx, image-2025-02-13-11-16-07-111.png,
> image-2025-02-13-11-54-45-830.png, image-2025-02-13-11-55-19-478.png,
> image-2025-02-13-11-57-55-829.png
>
>
> Hi
> observing strange behaviour of ExcelReader
> Workbook example [^Excel Test2.xlsx]
> Flow
> !image-2025-02-13-11-54-45-830.png|width=1730,height=187!
> Convert to CSV.
> ExcelReader -
> !image-2025-02-13-11-55-19-478.png|width=507,height=329!
> CSVRecordSetWriter
> !image-2025-02-13-11-57-55-829.png|width=505,height=455!
>
> if we dont have attribute ${sheetName} ExcelReader combines all sheets
> together (as expected) however the date stays in milliseconds
> {code:java}
> date,Something,Name
> 1738368000000,test1,Sheet1
> 1707696000000,test2,Sheet1
> 211248000000,aaa,Sheet2
> 540086400000,sss,Sheet2
> {code}
> If you provide sheet name - date formatted correctly
> {code:java}
> date,Something,Name
> 2025-02-01,test1,Sheet1
> 2024-02-12,test2,Sheet1{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
