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,
|
>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.
|
|
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.
|
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,
|
|
Please send your xls file, and we needn't that Java program since you have given us sql sample.
|
Main
webmaster@hxtt.com