Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.142
  HXTT Cobol 5.0.142
  HXTT DBF 7.1.143
  HXTT Excel 6.1.146
  Buy Now
  HXTT Json 1.0.114
  HXTT Paradox 7.1.142
  HXTT PDF 2.0.142
  HXTT Text(CSV) 7.1.142
  HXTT Word 1.1.142
  HXTT XML 4.0.143
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Excel
Jim Hobday
2011-08-15 03:51:14.0
I have a simple test spreadsheet XLS version with three columns
location id, name, county
111, Milton Keynes, Buckinghamshire
112, Chalfont St Giles, Buckinghamshire
117, Amersham,
113, Aylesbury, Buckinghamshire
114, Bedford, Bedfordshire
115, Luton,
116, Leighton Buzzard,

The County column has three "NULL" celld for 117, 115 and 116. Any select including "county" produces an NPE. If I enter a space in the three cells there is no problem (except that I want them to be nulls)

sqlCount=SELECT count(county), min(county), max(county) from "HasCountyNulls.xls".Locations
java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.e.a.a(Unknown Source)
at com.hxtt.e.a.if(Unknown Source)
at com.hxtt.sql.du.a(Unknown Source)
at com.hxtt.sql.du.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at com.hxtt.sql.bu.a(Unknown Source)
at Source)
at Source)
at Source)
at com.sentences.rdb.RdbMappingChapter.sampleRdbData(

I downloaded the 13.03MB today (link from - who purchased the excel driver) so it must be the latest one. The manifest includes:
Name: com/hxtt/sql/excel/
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-Title: com.hxtt.sql.excel
Implementation-Version: 4.0.022 on August 02, 2011
Specification-Vendor: Hongxin Technology & Trade Ltd.
Specification-Title: HXTT Excel JDBC 4.0 Package
Specification-Version: 4.0.022 on August 02, 2011
Comment: JDBC 4.0 Package for MS Excel

HXTT Support
2011-08-15 03:57:15.0
Please email us the HasCountyNulls.xls sample. Thanks.
HXTT Support
2011-08-15 04:28:23.0
Checked and fixed.
Jim Hobday
2011-08-15 04:33:30.0
Thank you - very speedy.

So how often do you create builds? When can I download the latest?

HXTT Support
2011-08-15 04:49:55.0
Since your second issue has been canceled. It will be availalbe after about 2 hours.
Jim Hobday
2011-08-15 04:52:16.0
brilliant - thanks
HXTT Support
2011-08-15 06:13:40.0
Please download the latest package.
Jim Hobday
2011-08-15 06:38:49.0
Sorry but the download page still has the 2nd August version:
Excel JDBC 4.0 Package 1,279Kb 2011-08-02 07:49

Do I go somewhere else for the latest packages?
HXTT Support
2011-08-15 06:51:44.0
Please relogin and download it.
Jim Hobday
2011-08-15 06:55:24.0
I can confirm that is fixed.

Thank you for such a fast service.


Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap