iLogic not finding sheet and column

[jonathan.victor]

I have an assembly, them i embed an excel xlsx via object insert command, run the code below, 

i = GoExcel.FindRow("Embedding 8", "Plan1", "DIAM_EIXO", "=", 200)

 Then iLogic throws error:

GoExcel: Could not match the column title: "DIAM_EIXO"

As you see the start cell in fact have the same and correct name "DIAM_EIXO" and still not finding, already tried changing the column title name with no sucess too. But when i use a defined path excel, (PATH/Tambor.xlsx) instead of embeded one the same code works great.

Before i was getting similar error whit code not finding the "Plan1" worksheet, and suddenly it worked fine, after changing the name several times (non-sense at all)

[JelteDeJong · Accepted solution]

have you seen this post

---

@MjDeck wrote:

How did you embed the spreadsheet? iLogic cannot find it if you use the Insert Object command. You have to embed it by using the Link button on the Parameters dialog.

---

I guess that you added the excel sheet in the wrong way.

[jonathan.victor]

Thanks for reply, i'll see the post with more attention later

[mrc_cnt88]

H

I'm having the same problem too, how did you solve it?