how to read Excel cell as string when the cell contains formula

[MikasaSe]

Hi,

I am trying to read an excel file (several worksheets, different nr of rows and nr of columns). I have tried to read each cell as a string type:

typedef basic_string<char, char_traits<char>, allocator<char> > string;

but the problem is that some cells contains calculation. such as "D1 = F2+10", in which case my code seems only read the value before the calculation sign, e.g. "F2". and even when the cell contains a hex number like 0x15, it will only read 0.

Is there a way that i can read the complete cell as a string? i don't want to manually copy each worksheet and paste it as Value, simply because there are too many worksheets.

Appreciate any suggestion!
Br,
Mikasa