Hi.
With the version Excel_JDBC30.jar i can't read the excel file data
Executing SELECT query will result in the following exception.
However, after opening the same Excel file, SELECT QUERY works well even if you SAVE it without modifying it.
I'll send the file through mail. Please take a look and solve this issue.
version of hxtt is
[ Specification-Version: 5.0.033 on February 22, 2018
Specification-Vendor: Heng Xing Tian Tai Ltd.
Comment: JDBC 3.0 Package for MS Excel
Implementation-Version: 5.0.033 on February 22, 2018]
java.lang.ArrayIndexOutOfBoundsException: 1
at com.hxtt.sql.cm.a(Unknown Source)
at com.hxtt.sql.ae.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.ea.a(Unknown Source)
at com.hxtt.f.m.if(Unknown Source)
at com.hxtt.f.b.a(Unknown Source)
at com.hxtt.f.m.if(Unknown Source)
at com.hxtt.sql.d3.a(Unknown Source)
at com.hxtt.sql.dg.byte(Unknown Source)
at com.hxtt.sql.dg.next(Unknown Source)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191)
|
What's your jdbc url?
In my test for your sample. jdbc:excel:/D:\\test\\excel\\Amazon_Forecast_Basic_20180211.xlsx?firstRowHasNames=4
select * from sheet0
No issue.
|
|
BTW, I'm using the latest package in yesterday.
|
Main
webmaster@hxtt.com