Support Questions
Find answers, ask questions, and share your expertise

Is there any support of xls files in nifi?

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

Accepted Solutions

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

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

Super 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.

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.

Explorer

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!

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:

Explorer

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