Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Is there any support of xls files in nifi?

avatar
Rising Star

I have data in my xls files and i want to process it in nifi but i am unable to find any processor which would help me with this. Is there any solution for it?

1 ACCEPTED SOLUTION

avatar
Expert Contributor
@Prakhar Agrawal

There doesn't seems to be an out of box support for xls files. Although you can use something custom for parsing xls files.

One of the examples:

https://community.hortonworks.com/questions/36875/where-to-convert-xls-file-to-csv-file-inside-nifi....

View solution in original post

6 REPLIES 6

avatar
Expert Contributor
@Prakhar Agrawal

There doesn't seems to be an out of box support for xls files. Although you can use something custom for parsing xls files.

One of the examples:

https://community.hortonworks.com/questions/36875/where-to-convert-xls-file-to-csv-file-inside-nifi....

avatar
Master Guru

Currently NiFi does not support XLS as a format, but there has been a community contribution to add a ConvertExcelToCSV processor under NIFI-2613.

avatar
Guru

Just to clarify https://issues.apache.org/jira/browse/NIFI-2613 currently only supports XSSF (.xlsx) based Excel documents. I do plan to add support for HSSF (.xls) in the near future.

avatar
Contributor

Is HSSF support still planned?  I'm trying to convert a bunch of older .xls spreadsheets, but they produce 0-byte files with the version of ConvertExcelToCSVProcessor we're using (1.12.1).

 

Thanks!

avatar
Community Manager

Hi @John_Wise, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
Contributor

Thanks @VidyaSargur - I just started a new thread, per your suggestion.