[
https://issues.apache.org/jira/browse/NIFI-14264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926844#comment-17926844
]
Daniel Stieglitz edited comment on NIFI-14264 at 2/13/25 4:31 PM:
------------------------------------------------------------------
[~dstiegli1] No problem. I actually submitted PR #
[9718|[https://github.com/apache/nifi/pull/9718]] for this yesterday. It seems
there is a bug in the POI library which is causing this.
was (Author: JIRAUSER294662):
[~dstiegli1] No problem. I actually submitted PR
[#9718|[https://github.com/apache/nifi/pull/9718]] for this yesterday. It seems
there is a bug in the POI library which is causing this.
> 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)
