Is there any support of xls files in nifi?

[#1]

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?

[#2 · Accepted solution]

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

[#3]

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

[#4]

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.

[#5]

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!

[#6]

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.

[#7]

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