Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Excel
Data type
BM Kim
2007-09-10 03:22:31.0
First, I thank you for your kind answer about my previous question.
I have one more question about data type.

My excel have one sheet named TABLE2.
TABLE2 sheet have four column - ID, DESC, WEIGHT, ISNEW
ID and ISNEW has values for each row. actually WEIGHT has value typed VARCHAR
and ISNEW has value typed DOUBLE.
But DESC and WEIGHT has no value, in other word, empty space for that.

And I extract type for each column.
the result is :
[ID] is typed VARCHAR
[DESC] is typed VARCHAR
[WEIGHT] is typed JAVA_OBJECT
[ISNEW] is typed DOUBLE

I take "general type" for all 4 colums with right mouse click - cell confgiruation - display format.

What I want is,
1. DESC and WEIGHT is all empty. Is there any reason that [DESC] is VARCHAR and [WEIGHT] is JAVA_OBJECT ?

2. Can I get the column type from "display format" in excel?
if all data for one column is empty, I must use default value and there is some diffrernce between default value for VARCHAR, default value for DOUBLE and default value for DATE.

Best Regards,
Re:Data type
HXTT Support
2007-09-10 05:19:33.0
>1. DESC and WEIGHT is all empty. Is there any reason that [DESC] is VARCHAR
> and [WEIGHT] is JAVA_OBJECT ?
DESC should have at least a no-null cell with text format. all cells of WEIGHT is null value so that it doesn't know the data type.

>2. Can I get the column type from "display format" in excel?
Good idea. We can add that feature for DOUBLE and DATE.
Re:Re:Data type
HXTT Support
2007-09-11 06:09:44.0
v1.1.070 can detect data type from "display format" in excel when it meets empty cell. It should be released after about 48 hours.
Re:Re:Re:Data type
BM Kim
2007-09-13 22:33:07.0
Thanks for your enhancement.

I have more question about data type.
I have two excel file - both has two empty column typed DATE and DOUBLE.
My HXTT program recognize DATE and DOUBLE in one, but
he doesn't recognize DATE and DOUBLE in other - he recorgnize both column as JAVA_OBJECT.

the result is :
select * FROM TABLE2
[ROUTE_ID] is typed VARCHAR
[ROUTE_NAME] is typed VARCHAR
[WEIGHT] is typed JAVA_OBJECT
[WEIGHT_BATCH] is typed DOUBLE
[DISPATCH_FULFILL] is typed VARCHAR
[AVAILABLE_START_DATE] is typed JAVA_OBJECT

[WEIGHT] is double and [AVAILABLE_START_DATE] is date

and
select * FROM TABLE2
[ID] is typed VARCHAR
[DESC] is typed DOUBLE
[WEIGHT] is typed DATE
[ISNEW] is typed DOUBLE

Would you let me know what is wrong in my excel?
if you allow me, I'll send my excels and my java program to webmaster@hxtt.com.

Best Regards,
Re:Re:Re:Re:Data type
HXTT Support
2007-09-13 22:38:52.0
Please send your xls file, and we needn't that Java program since you have given us sql sample.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap