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:
The other sheets are blank.
When I read the metaschema using getTables(null, null, null, "TABLE") I get
But Sheet2 has the two columns (and the other two are blank)
Implementation-Vendor: Hongxin Technology & Trade Ltd.
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
>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.
I used Excel 2007 to rename the first Sheet, not through the HXTT driver.
I'm so sorry - my mistake - I had obviously moved onto the second sheet when I created the columns.
Thanks for your help
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.
Sorry about that. Monday mornings eh!