Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.150
  HXTT Cobol 5.0.150
  HXTT DBF 7.1.151
  HXTT Excel 6.1.154
  Buy Now
  HXTT Json 1.0.122
  HXTT Paradox 7.1.150
  HXTT PDF 2.0.150
  HXTT Text(CSV) 7.1.150
  HXTT Word 1.1.150
  HXTT XML 4.0.151
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
Issue with decimal numbers
Paul Gibbs
2018-04-11 08:07:27.0
Hi, I have an XLS file which I need to process and which I recently purchased the Excel driver from yourselves to achieve this.
There are several columns in the file that contain decimal numbers.
When I view the XLS file using Excel, an example of the value displayed would be
0.0012 , however, if I click on the cell, the actual value shown in the top bar is actually 0.00118609793531707
When I select this column using the 4.1 driver, the SQL returns 0.0012.
As there are several thousand rows in the file, this "rounding" means when I sum the result set, the total is significantly different.
Is there a way to retrieve the actual values from the cell rather than the displayed values, ideally without having to change the formatting in the XLS as this will be an automated process to retrieve and query the files.
Re:Issue with decimal numbers
HXTT Support
2018-04-12 06:32:36.0
Supported. Please download the latest package. Now it will return 0.00118609793531707.

If you use withForamt=true connection property, it will return 0.0012 .
Re:Re:Issue with decimal numbers
Paul Gibbs
2018-04-13 06:06:33.0
Thanks for the quick fix. Have tested and full decimals are now returned.

Slightly confused regarding the property you have added to make driver behave as it used to (ie only return displayed numbers).

(If you use withForamt=true connection property, it will return 0.0012 .)

Please confirm the exact property I need to add to the connect string to use this setting as I can't seem to make it return the shortened values now

Re:Re:Re:Issue with decimal numbers
Paul Gibbs
2018-04-16 00:49:49.0
Any update on this question

I have tried Format=true, Foramt=true, withFormat=true and withForamt=true and all still return the full number of decimals

Please explain

Re:Re:Re:Re:Issue with decimal numbers
HXTT Support
2018-04-16 04:45:48.0
Sorry. A typo.


For instance, jdbc:excel:/yourPath?withFormat=true

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap