Problem reading Excel Cells if they contain formula values

[AlexFielder]

Somewhat related to this topic can anyone tell me why iLogic seems unable to read values from Excel worksheets when the values contained therein are generated by an Excel formula (VLOOKUP for instance)?

Do I really need to copy/paste as text all the cell values I wish to make use of?

Thanks,

Alex.

[xiaodong_liang]

Hi,

Can I understand your question is:  if the cell is a formula, iLogic cannot read the value out? 

I simply made an excel with one cell which is formula, and read it from iLogic. It works well. 

Could you elaborate the question with neccessary snapshot of demo files?

GoExcel.Open("c:\temp\Book1.xlsx", "Sheet1")

 DimoV

 oV = GoExcel.CellValue("c:\temp\Book1.xlsx", "Sheet1", "C1")

 MsgBox(oV)

 GoExcel.Close 

[AlexFielder]

Hi Xiaodong,

It's been while since we last spoke. 😉

Having looked into this again since posting, I think the problem I was having stems from my copy of Excel having an addin called "Regex Find-Replace" installed; the cells iLogic had an issue with were referencing cells with formulae generated by that tool.

When I get time I'll post a spreadsheet containing some of the formulae I am referring to- although you'd need that addin installed to be able to see the formulae so maybe it's a waste of time?

Thanks,

Alex.

[xiaodong_liang]

Hi Alex,

firstly, sorry for our late response.

if an expected behavior is wrong, it is worth to know, and we can report it to the engineer team if it is indeed an issue. But if the problem occurred by 3rd tool, it will be hard for us to know how it happened. for such scenario, what we could help is to get to know your exact requirement, and try to find the workaround without the 3rd tool.