Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.0
  HXTT XML v3.0
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
Metaschema wrong for XLSX
Jim Hobday
2011-08-15 03:59:51.0
I have a simple test XLSX spreadsheet with three sheets. I renamed "Sheet1" to "XLSX1"

This first sheet contains two columns ID and Name and 4 non-null rows:
ID, Name
1, Jim
2, Bob
3, Fred
4, George

The other sheets are blank.

When I read the metaschema using getTables(null, null, null, "TABLE") I get
Tables:
"XLSX/Book2007.xlsx".Sheet2
"XLSX/Book2007.xlsx".Sheet3
"XLSX/Book2007.xlsx".XLSX1

But Sheet2 has the two columns (and the other two are blank)

Cheers
Jim

Manifest entry:
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
Implementation-URL: http://www.hxtt.com/excel.html
Specification-Version: 4.0.022 on August 02, 2011
Comment: JDBC 4.0 Package for MS Excel
Re:Metaschema wrong for XLSX
HXTT Support
2011-08-15 04:27:58.0
>I renamed "Sheet1" to "XLSX1"
Through HXTT Excel or MS Excel?

>But Sheet2 has the two columns (and the other two are blank)
Please email us the sample.
Re:Re:Metaschema wrong for XLSX
Jim Hobday
2011-08-15 04:34:25.0
I used Excel 2007 to rename the first Sheet, not through the HXTT driver.
Re:Re:Re:Metaschema wrong for XLSX
Jim Hobday
2011-08-15 04:39:02.0
I'm so sorry - my mistake - I had obviously moved onto the second sheet when I created the columns.

Thanks for your help

Jim
Re:Re:Re:Re:Metaschema wrong for XLSX
HXTT Support
2011-08-15 04:48:39.0
Yeah. Checked.
null Book2007.xlsx Sheet2 ID 4 INTEGER 11 null 0 10 1 ID null null null 254 1 YES
null Book2007.xlsx Sheet2 Name 12 VARCHAR 6 null 0 10 1 Name null null null 254 2 YES
null Book2007.xlsx Sheet3 A 12 VARCHAR 64 null 0 10 1 A null null null 254 1 YES
null Book2007.xlsx XLSX1 A 12 VARCHAR 64 null 0 10 1 A null null null 254 1 YES

Because Sheet3 and XLSX1 is empty sheet, so that HXTT Excel contains only one column A to prompt it.
Re:Re:Re:Re:Re:Metaschema wrong for XLSX
Jim Hobday
2011-08-15 04:50:44.0
Sorry about that. Monday mornings eh!

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap