[teiid-issues] [JBoss JIRA] Commented: (TEIID-965) Need Excel file importer / connector

[Ivan Vasyliev (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584834#comment-12584834 ] 

Ivan Vasyliev commented on TEIID-965:
-------------------------------------

Additional XLS/JDBC driver (POI/jsqlparser based):
http://code.google.com/p/sqlsheet/
Usage example:
http://scriptella.javaforge.com/docs/api/scriptella/driver/xls/package-summary.html

> Need Excel file importer / connector
> ------------------------------------
>
>                 Key: TEIID-965
>                 URL: https://issues.jboss.org/browse/TEIID-965
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>
> Really need to add an Excel connector in SP1.  The easiest way to do this is probably with one of the open source JDBC drivers that work over Excel files.  
> Something like:
> https://xlsql.dev.java.net/ - Excel JDBC driver (GPL unfortunately, so we probably can't distribute the driver)
> http://www.andykhan.com/jexcelapi/ - Java Excel API (GPL too)
> http://xlsjdbc.sourceforge.net/ - LGPL (uses Apache POI), really cheesy and maybe not being updated
> http://jakarta.apache.org/poi/ - Excel API, event-based and not particularly friendly
> http://www.vistaportal.com/products/vistajdbc-QA.htm - commercial

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira