Excel read cell formula

[SphinxsBSL]

I have to write a little program thas is able to convert an Excel file in fixed format (cells to read are all over the excelsheet) to a textfile, also in a fixed format.

There are 2 problems:

1) This program should be used by multiple users, and I don't know the version of their Office in advance

2) How can I read the value behind a formula? Some fields contain for example '005', but others contain for example '=D12'.

 

I hope someone can give some advice!

Thanks!

Bart.