Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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

Start
Prev
1
Next
End

Nicolas Verscheure
Topic Author
Offline

26 Nov 2014 10:07 - 16 Feb 2015 10:11 #1 by Nicolas Verscheure

How to retrieve the value of the formulas of an Excel sheet ? was created by Nicolas Verscheure

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)

Thomas BLETON
Offline

16 Feb 2015 11:40 #2 by Thomas BLETON

Replied by Thomas BLETON on 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.

Start
Prev
1
Next
End