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.
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
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.