AnsweredAssumed Answered

Excel: getting data from a cell

Question asked by sergio on Nov 5, 2010
Latest reply on Nov 7, 2010 by sergio

Like • Show 0 Likes0
Comment • 4

Hi,

I have a cell where a formula is defined. Formula works fine and I see "Y" in this cell.
So I would like to get this "Y" in my VEE application.

When trying to retrieve(using xLIB.DataFromCell) a data from cell I am getting the formula(e.g =IF(A1=1,"Y","N")).
How I can get my data?

Thanks.

No one else has this question

Outcomes

4 Replies

PingWei Nov 6, 2010 1:13 AM
Mark Correct
Correct Answer
Perhaps you can try to use xlLib.EvalCellFormula instead of xLIB.DataFromCell.
The object is located at Excel>GetData>Evalate Cell Data.
Hope it's work for you.
Like • Show 0 Likes0
Actions
sergio Nov 6, 2010 3:06 AM
Mark Correct
Correct Answer
I have tried this already before.
but got some big negative value instead.
Like • Show 0 Likes0
Actions
PingWei Nov 6, 2010 6:47 PM
Mark Correct
Correct Answer
I have tried to retrieve value for =IF(A1=1,"Y","N") by using xlLib.EvalCellFormula
it show 'Y' and 'N', I did not see any negative value. :?

I get a very large -ve number only if i hv performed 'EvalCellFormula' from a blanked cell.
Attachments
- excel1.vee16.0 KB
Like • Show 0 Likes0
Actions
sergio Nov 7, 2010 3:29 AM
Mark Correct
Correct Answer
i have more complicated formula where some cells from another sheet are being involved.
i'll try out xlLib.EvalCellFormula again.

so far i have solved my issue by moving formula to VBA script so my target cells do not have formula anymore but the result of formula.
Like • Show 0 Likes0
Actions

Excel: getting data from a cell

Outcomes

Attachments

Related Content

Recommended Content