reading value in Excel

kalliet

hello,

I have a strange problem :
when I read a value from Excel, I do not always get the correct value (I sometimes get the previous read cell)

I use following code
l_readValue = sheet.cells().item(j,i).value().double();
l_endValue = l_readValue + (-1 * ReqTrans.Qty);

Am I missing something?

thx in advance,
Kalliet

kalliet

something extra I discovered (but still no solution for it) :

if
sheet.cells().item(j,i).value() == VT_EMPTY
then
sheet.cells().item(j,i).value().double() becomes an arbitrary value.

How can I see - in code - if the value is VT_EMPTY, so I can force the result to 0 ?

thx,
Kathleen