question Re: Is there any support of xls files in nifi? in Archives of Support Questions (Read Only)

Is there any support of xls files in nifi?

prakharagrawal6 — Wed, 15 Mar 2017 15:31:08 GMT

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?

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

nyakkanti — Wed, 15 Mar 2017 15:37:23 GMT

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

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

mburgess — Wed, 15 Mar 2017 19:56:42 GMT

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?

jdyer — Wed, 15 Mar 2017 20:02:09 GMT

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?

John_Wise — Mon, 10 May 2021 19:01:32 GMT

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?

VidyaSargur — Tue, 11 May 2021 07:30:52 GMT

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.

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

John_Wise — Tue, 11 May 2021 12:09:38 GMT

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