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

Is there any support of xls files in nifi?

Solved Go to solution

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

Re: Is there any support of xls files in nifi?

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

Re: Is there any support of xls files in nifi?

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

Re: Is there any support of xls files in nifi?

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.

Re: Is there any support of xls files in nifi?

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.

Re: Is there any support of xls files in nifi?

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!

Re: Is there any support of xls files in nifi?

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:

Re: Is there any support of xls files in nifi?

Explorer

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