Excel link with embedded sheet

[TONELLAL]

Hi,

I try to use an embedded Excel sheet to use it with iLogic.

The rule :

i = GoExcel.FindRow("3rd Party:Embedding 1", "Feuil1", "TYPE", "=", "A")

 I have the hereunder error, but I can't find where is the problem...

If I use an external XLS file it's ok :

i = GoExcel.FindRow("C:\temp\test.xlsx", "Feuil1", "TYPE", "=", "A")

The ipt file is joined, you can test it.

I precise I use French Inventor 2016 R3.

All ideas welcome !

[HermJan.Otterman]

Hello can't see what you are doing wrong, except for the Sheetname..

but when the right sheetname is entered it still does not work.

I created a new one in my inventor 2019 and it works fine (see the screencast)

I don't have 2016 running any more, sorry

[HermJan.Otterman · Accepted solution]

the Inventor lines:

'i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "columnName", "<=", 0.2)

i = GoExcel.FindRow("3rd Party:Incorporation1", "toto", "TYPE", "=", "A")

my screencast....