[ 
https://issues.apache.org/jira/browse/NIFI-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15887280#comment-15887280
 ] 

ASF GitHub Bot commented on NIFI-2613:
--------------------------------------

Github user jvwing commented on the issue:

    https://github.com/apache/nifi/pull/929
  
    Thanks, @jdye64,  that got it.  I was able to build just fine with 
contrib-check and everything.  On to new topics:
    
    * **License/Notice** - We need a separate LICENSE and NOTICE files for 
nifi-poi-nar.  I was reminded by the recent LICENSE/NOTICE discussion on the 
mailing list about what to include in NAR bundles, and it applies here.  Good 
news, you've already put together most of the text for the nifi-assembly 
LICENSE/NOTICE, and there are many examples of the file layout in other NARs.  
I think a reasonably comparable NAR referencing another Apache project is 
[nifi-ignite-nar](https://github.com/apache/nifi/tree/master/nifi-nar-bundles/nifi-ignite-bundle/nifi-ignite-nar/src/main/resources/META-INF).
    * **Sheet in Filename** - Output filenames all have the UNKNOWN sheet name, 
like `35200238025098_UNKNOWN.csv`.  How about adding a sheet name check to one 
of the unit tests?
    * **Error Cases** - What will make this fail?


> 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)

Reply via email to