You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Philipp Korniets (Jira)" <ji...@apache.org> on 2025/02/13 11:32:00 UTC
[jira] [Updated] (NIFI-14264) ExcelReader + SplitExcel - date stays in Excel format
[ https://issues.apache.org/jira/browse/NIFI-14264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Philipp Korniets updated NIFI-14264:
------------------------------------
Summary: ExcelReader + SplitExcel - date stays in Excel format (was: ExcelReader + SplitExcel - date format)
> ExcelReader + SplitExcel - date stays in Excel format
> -----------------------------------------------------
>
> Key: NIFI-14264
> URL: https://issues.apache.org/jira/browse/NIFI-14264
> 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
>
>
> 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)