I currently have a spreadsheet that contains numbers that have a formatting applied to be represented as integers. However at run-time values for this column always comes back as a Double.
What mechanisms are there that I can expect to get my data back as an Integer instead of a Double?
Thanks!
Ed
|
>I currently have a spreadsheet that contains numbers that have a
> formatting applied to be represented as integers.
You can zip and send us a sample so that we can check whether it's possible for HXTT Excel to detect automatically it as int.
>What mechanisms are there that I can expect to get my data back as an
> Integer instead of a Double?
For instance, INT(x) : truncates x to nearest integer at Scalar Functions and Aggregate Functions.
|