Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question How to retrieve the value of the formulas of an Excel sheet ?

  • Nicolas Verscheure
  • Nicolas Verscheure's Avatar Topic Author
  • Offline
More
26 Nov 2014 10:07 - 16 Feb 2015 10:11 #1 by Nicolas Verscheure
Nicolas Verscheure created the topic: How to retrieve the value of the formulas of an Excel sheet ?
I want to retrieve the value of the formulas of an Excel sheet, is it possible ?

The only information found on Excel's driver either on this site or in Stambia's Help is the "Getting started with Stambia's JDBC Excel driver" .
Last Edit: 16 Feb 2015 10:11 by Thomas BLETON. Reason: (edit: changed link url to reflect new article id)
More
16 Feb 2015 11:40 #2 by Thomas BLETON
Thomas BLETON replied the topic: How to retrieve the value of the formulas of an Excel sheet ?
When an Excel document is saved, the current formula values are saved in the file.
Stambia's Excel driver retrieves this saved value. There is no way to force a new calculation of the formulas.