[
https://issues.apache.org/jira/browse/NIFI-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15926234#comment-15926234
]
ASF GitHub Bot commented on NIFI-2613:
--------------------------------------
Github user jdye64 commented on the issue:
https://github.com/apache/nifi/pull/929
@jvwing In regards to error cases here are a list of things which could
make this fail.
- Input data is incorrect. AKA not .xlsx file
- Empty document. I guess this isn't an error but I think you get what I'm
saying there just wouldn't be anything to do.
- User could specify a list of "desired-sheets" that are not present in the
document. Once again not really failure but of course no success relationships
would be triggered on the original relationship.
- The processor will currently only process strings (this includes
numerical values, just the POI naming convention) and will ignore things like
graphs, images, binary data, etc.
> Support extracting content from Microsoft Excel (.xlxs) documents
> -----------------------------------------------------------------
>
> Key: NIFI-2613
> URL: https://issues.apache.org/jira/browse/NIFI-2613
> Project: Apache NiFi
> Issue Type: New Feature
> Components: Extensions
> Reporter: Jeremy Dyer
> Assignee: Jeremy Dyer
>
> Microsoft Excel is a wildly popular application that businesses rely heavily
> on to store, visualize, and calculate data. Any single company most likely
> has thousands of Excel documents containing data that could be very valuable
> if ingested via NiFi and combined with other datasources. Apache POI is a
> popular 100% Java library for parsing several Microsoft document formats
> including Excel. Apache POI is extremely flexible and can do several things.
> This issue would focus solely on using Apache POI to parse an incoming .xlxs
> document and convert it to CSV. The processor should be capable of limiting
> which excel sheets. CSV seems like the natural choice for outputting each row
> since this feature is already available in Excel and feels very natural to
> most Excel sheet designs.
> This capability should most likely introduce a new "poi" module as I envision
> many more capabilities around parsing Microsoft documents could come from
> this base effort.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
