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)
|
But tha issus should have been replied.
I have tested your sample with the latest package in March. No issue
I used the jdbc url: jdbc:excel:/D:\\test\\excel\\Amazon_Forecast_Basic_20180211.xlsx?firstRowHasNames=4
select * from sheet0
|
Main
webmaster@hxtt.com