- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
how to convert CSV to excel using apache nifi
- Labels:
-
Apache NiFi
Created ‎12-13-2021 06:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello everyone
in this day I tried to convert CSV file to xlsx file using Apache nifi
but i couldn't anyone knows?
or any idea on how to get NIFI flow output as .xlsx file
Created ‎12-13-2021 11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Saraali
NiFi on contains components for reading XLXS files and converting them to CSV. There are no native components included with NiFi that can convert the other direction.
That being said, NiFi offers numerous processors that allow you to execute your own scripts or external commands against the content of a NiFi FlowFile.
Here is an example where someone converted from CSV to Excel by passing the FlowFile content to an externally executed python script:
https://stackoverflow.com/questions/68937735/how-to-convert-csv-to-excel-using-python-with-pandas-in...
If you found this response assisted with your query, please take a moment to login and click on "Accept as Solution" below this post.
Thank you,
Matt
Created on ‎12-13-2021 09:20 PM - edited ‎12-13-2021 09:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Matt
Well, I see that I saw this link and tried but I got this error
another thing
when flow from NIFI return CSV there is encoding problem because that i want to convert csv to excel
like this :
How Can I solve this problem ?
Created ‎12-14-2021 11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Saraali
I'd love to help, but I have never done any scripting to convert to excel format. All I can tell you is there is no native processor available in NiFi that does this conversion.
I'd recommend raising a new feature request jira in apache for NiFi:
https://issues.apache.org/jira/projects/NIFI/issues/
Perhaps others in the community may be looking for the same capability who are willing to contribute code?
Thanks,
Matt
