aspose file tools*
The moose likes JDBC and the fly likes Reading calculated values from Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reading calculated values from Excel" Watch "Reading calculated values from Excel" New topic
Author

Reading calculated values from Excel

Sheetal Karnik
Greenhorn

Joined: Sep 30, 2002
Posts: 1
We have an excel sheet which has a lot of complex calculations/formulae embedded into it.
We update some cells which act as input to these calculations. The final result is displayed on the same worksheet in a different cell. We have to pick this value & display it to the user.
We are using jdbc to connect to XL. The problem is :
When the XL sheet is open & the program is run, the correct(changed) value is read.
However, if XL sheet is closed & the input supplied changes, the final value read does not reflect the change(wrong value).
When we open the excel sheet after the run, we see the correct(i.e changed) value in XL.
Thanks in advance for any help!!
Sheetal.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading calculated values from Excel